I am working on a flow, where I use quite a lot of excel writers and I would like to use a variable counter to use for naming. So for example everytime an excel writer writes some data, the counter needs to update so 1,2,3 etc.
I am new to using loops and I can’t seem find the right nodes to use.
Additionally, how do I ensure that the counting sequence is the same across all executions? So an excel file called tax_1 isn’t suddenly called tax_3 on the next execution.
Without knowing the structure of your workflow, its difficult to try to provide a solution. Do you have multiple Excel Writers in your workflow each of which you want to increment for each execution?
Thanks for taking the time to reply. I have made a small flow to illustrate how the structure is. I have also found a solution to both the counting variable and execution order, but I don’t think this is a very elegant way of doing it.
Additionally, I would like to have the number as a part of a larger “naming string” for the sheet name, instead of having just the number as the sheet name. For example tax_subgroup_1, tax_subgroup_2.
Do you want a single workbook with multiple named sheets or multiple workbooks? This is a critical issue for developing a workflow. Could you share your workflow?