I have several workflows with multiple outputs, which I have generating on an Excel document. However, I haven't found a rhyme or reasoning to the order of the sheets on my output document. Does anyone know of a way to control the output? In other words, a way to set my first output to the first tab in Excel, second output to the last tab in Excel, etc. Please let me know if this is something we can control in Alteryx. Thanks!
In Designer the output for the Excel sheets will be in alphabetical/numerical order. If you would like to amend this, the best way would be to add a numerical or alphabetical prefix to the field names to reflect the order you would like them to be output in.
Hi Will, thanks for the reply! Are you saying they are in order based on the sheet name or actual data on the sheets? If it is by sheet name, I do not think the Designer is doing that. Attached is the order of my sheets for a workflow I have. Thanks! - Mike
Thanks for the reply Meteor! Only issue I see in the sample you sent is that each stream is coming from one input, not multiple like I have. In one workflow, I have 5 outputs from 2 inputs, while my other, I have 2 outputs from 8 input documents. The example I see below has 1 input generating all 3 outputs. If you have any other suggestions for my specific ask, please let me know. Thanks!
I see. One way to fix that would be to create a workbook with the sheets already created and in the order you want them, and then just have the multiple workflows overwrite the existing sheets. That will maintain the order regardless of which sheets get overwritten first.