Hi
I am just working on a dataset where I have one input file that goes through several different processing paths and I am trying to create one output sheet for Excel.
I can merge the different paths/sections together with stacking them and that works with the columns, but I’d like to have some explanation for each output block in the output file.
I can add blank new rows between the stacked pieces, but I’d like to have additional texts - so I am looking for a way to have some specific text like “Total Month’s Sales” and “Funds deposited the following month”.
The only way I can find built in is to have either blank lines, or have every column have the same text, but I just want the text in the first column.
The only thing I can think of to solve it is to have empty or prefilled files that I can then stack in at the right time, but I was wondering if there’s an easier way for this type of “output formatting” to add notes to the Excel sheets it generates?
Are you describing creating a dummy first row of anything, e.g. a Stat, for the first column, then Replace the resulting entry with your description? Two steps for each piece, then Stack.
I guess that could work as well. I was just thinking of creating a new input file with the data and then stack that.
That project is working on a monthly payment processing for Shopify that has three separate paths right now.
One is for all transactions in that month, the second for the transactions that will settle in the next month and the third path splits out collected and deducted sales taxes that will be accounted for in the next month.
I did finally find now the “Stamp” transform which allows me to have some text describing how to enter/compare the section in Quickbooks.
It’d be nice to be able to have a specific text in each column to work on additional headers, but at least Stamp allows me to enter custom text into each section in the first column.
I just started it with the first section - and that’s the screenshot - and then I’ll have to finish by adding more text lines to the other sections.
Stamp is one way to do it.
Also you can copy text like “Total Month’s Sales” to the clipboard, add it as a clipboard input and then include it in the correct place in the Stack.
Oh yeah - clipboards don’t auto-update like files, do they? Thank you.
Correct. They are stored in the .transform and don’t change, unless you explicitly paste from the clipboard into them.