Output file sheets in specific order

[sericson]

My team parses out data from excel files through Alteryx and put into one output file with multiple tabs, is there a way to have the tabs output in the same order every time? 

[binuacs]

@sericson Are you parsing the excel files with the help of batch macro? do you have any specific orders for the tabs? can you attach sample input files and expected output?

[rzdodson]

As @binuacs is suggesting, there are numerous ways you can accomplish this. The easiest I have personally found is: 1) prep your Excel template file with the order you want those sheets in first, then 2) use Alteryx to write to those sheets. 

First picture displays the dummy data that I am working with that I am interested in dropping in to the Excel file I have created.

Then, you are going to create a formula tool that starts building out your Output path. For this, you will need the full path and file type of your file. Then, insert three pipes (Shift + \ on most keyboards). Then, insert your tab name. In my use case, I have called that "Group".

Then, you are going to change some settings in your Output tool. In this case, you are overwriting the sheet or range. You are going to take the file/table name from the Output path field, and then tell Alteryx to drop the Output field from the final output to get the result you are looking for.

Finally, you can always double check your work in the Results window. In this use case, Alteryx will tell you just how many records are writing to each sheet.