Column Order of Dataset

calvert_schaefer

I am currently trying to re-order the columns in my dataset however in the final product, it appears to be maintaining the previous order.

ETL attachment shows order via the preview section of magic ETL

output attachment shows order of columns in the dataset.

OUTPUT.png

etl.png

ArborRose

When working on the data from the data center, there's a schema option in the upper right:

You can reorder the column from that command. But they will not stay in that order. If the ETL is modified or the process re-runs, it will most likely change the order back.

Under Admin > Governance > Toolkit, there is also a schema management tool.

GrantSmith

You can use a Select Column tile to set the ordering of your columns in your output dataset.

ArborRose

When working on the data from the data center, there's a schema option in the upper right:

You can reorder the column from that command. But they will not stay in that order. If the ETL is modified or the process re-runs, it will most likely change the order back.

Under Admin > Governance > Toolkit, there is also a schema management tool.