Skip to content

    • Charting

    Charting

    Column Order of Dataset

    Member
    in Charting

    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.

    Image
    OUTPUT.png
    Uploaded 13.03 KB
    Image
    etl.png
    Uploaded 12.11 KB

    Best Answer

    • 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

    • 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!**
    • 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! **

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories