Output as excel and column are distorted

[newlearner123]

Hi~

I have developed a workflow and output as 10 excel tab. However I found that the order of column in excel output are different with the column order in basic table tool. I have also tried to add a select tools to re-order the sequence, but it doesn't work.

The only way I can do is to untick all column in table tool and select again... But it is time consuming if I have to do this for all of my output files everytime i run the workflow. 

I notice the issue happens everytime when I input a new input file, which the column number might be different everytime, then the column order will be distorted like the below.  Please help!

Output:

Table:

[JagdeeshN]

Hi @newlearner123 ,

Please find attached a sample workflow to showcase how it can be implemented. You would need to change the list of fields to be in the order you want them in.

By this method, you force the ordering through the list before creating a table.

Hope this helps.

Best,

Jagdeesh