Report to a new Tab in Excel

Question

hello - i have this existing process:

i runs the same query multiple times using different parameters read in from a input table. how do i set it up to write the output to a different excel tab for each run?

im not seeing that option:

currently i only get the last result. all the other results are overwritten.

avuong6 · Answer

so i think i got it working with your guidance. thank you.

also, if i wanted to append the text selected in this update action:

how to update formula to get that field in?

FinnCharlton · Answer

Hi @avuong6 , I would approach it like this. First, use a formula tool to make a new File Path + Sheet Name for each iteration of the macro:

Here, each time the macro runs this calculation will result in a different Sheet Name. Now, in the output tool select 'Overwrite Sheet or Range'. Lower down, select 'Take File/Table Name From Field' and Select 'Change Entire File Path'. Choose your File Path field from the drop-down below:

Now each time the macro runs, a new file path will be generated and will be used to change the sheet we output into. Hope this helps!