Report: TABS in different order and unexciting file

[neromerob]

Hello to everyone. 

In working in a workflow that looks like this. 

during my first attempt to make it work (with dummy table to create TAB1, TAB2, AND TAB3) everything seems to work. 

Them I try with the real data. and two thigs happened. 

First, the file is not being created in the folder, so I decided to test it as a temporary excel file. 

and second, the result is that the report is being organize in alphabetical order. 

This is how I have the union tool, trying to get the order that I want. 

thank you. 

[ddiesel · Accepted solution]

Hi @neromerob!

I'm not sure if there is an easier way to do this, but here are two possible workarounds you can try:

1) Add a prefix to the sheet names like "01_Summary" and "02_Data". (I prefer this method)

2) Use block until done to write one sheet at a time. (There are lots of posts about how to do this here in the community.)

Let us know if either of these solutions work for you. 

Thanks,

Deb