Column Order of Dataset

Options
calvert_schaefer
calvert_schaefer Member
in Charting & Analyzer

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

Best Answer

  • ArborRose
    ArborRose Coach
    Answer ✓

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

    image.png

    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.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Answers

  • GrantSmith
    GrantSmith Coach

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

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • ArborRose
    ArborRose Coach
    Answer ✓

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

    image.png

    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.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Categories