Table Tool Output Formatting

Question

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/2019CallsACW Time (seconds)ACW Time (minutes)Team Calls %RefusedDQ_sTeam 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.

CallsACW Time (seconds)ACW Time (minutes)Team Calls %RefusedDQ_sTeam DQs %Change_Order12/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

danilang · Accepted Answer

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 Answer

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!