Table Tool Output Formatting

[kkahle]

Hello, 

When I use the Table tool in my workflow it is rearranging my data columns and I can't figure out why. 

Below is the order of the columns before the data is run through the Table tool. 

12/16/2019

Calls

ACW Time (seconds)

ACW Time (minutes)

Team Calls %

Refused

DQ_s

Team DQs %

Change_Order

After the data has bee run though the Table tool the column with today's date (12/16/2019) is moved all the way to the right.

Calls

ACW Time (seconds)

ACW Time (minutes)

Team Calls %

Refused

DQ_s

Team DQs %

Change_Order

12/16/2019

Any idea why this is happening and how I can prevent the columns for being rearranged?

Unfortunately, I can't upload the workflow but please let me know if there is any other information I can provide. 

Thanks,

Kurt

[WilliamR]

hello @kkahle ,

you can reorder your fields in the table tool if you want using the arrows at the bottom.

(If this post helps, then please consider Accept it as the solution to help the other members find it more quickly).

[danilang · Accepted solution]

Hi @kkahle 

In the test I tried(attached), the column order is preserved when passing through the table tool

 

If your date column is the result of a transpose or other dynamic operation, it will get pushed to the back since it's a Dynamic or Unknown field and in the table tool these are always placed at the end.  If you move the Dynamic or Unknown Fields to the top of the list in config of your table tool any new fields will always show up at the start

Dan

[kkahle · Accepted solution]

Thanks Dan! I never paid attention to the "Dynamic or Unknown Fields". It made a lot of sense, after you explained it. 

Thank you again!