Order By

ArborRose · 2024-07-02T19:04:36+00:00

There was an error rendering this rich post.

Why does the order of elements change every time we run an API or an ETL? If I put a select column tile on an ETL, immediately followed by an output, I would expect the output fields to be in the order of the select column tile.

I'm currently working on a complex aging flow and running the flow makes the dataset wonky and I find myself spending so much time mapping fields because I have to keep re-ordering the dataset.

Find more posts tagged with

Magic ETL

Comments

MarkSnodgrass

@ArborRose you can actually set the order of the output dataset without modifying the ETL and adding a select columns tile. In the Data Center, click on your dataset and then click on Data and then the Schema icon that is on the right. Hover over the left side of the page and you can click and drag any column to the order that you want.

ArborRose

@MarkSnodgrass - that doesn't hold the order. As I mentioned, when the ETL is modified or an API reruns every morning the dataset order changes.

ArborRose

@Admin - this was posted as a discussion, not a question. And yes, I would like to know if anyone has a way to "save" the order. I am still working on this AR dataset and have to reorder all the fields (the way Mark describes) every time I update my ETL.