Sort Column in ETL?

I am trying to import some old Data and merge it with data from a connector but the data is in different orders.  The legacy data went decending

 

1

2

3

4

 

but when I merge the data with the connector its adding to the top so I get

 

5

1

2

3

4

 

I was just wondering, is it possible to merge the data onto the bottom or sort the legacy data so that its all in order, or is the only option to actually sort it within the card?

 

Thanks

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🥷
    Answer ✓

    Ordering the data in the table should not be necessary unless you just find it easier to look at it when you are in the data center and looking at the data of a dataset. Having said that, you could use the Rank & Window tile to order one dataset before the other if you really wanted it stacked in a certain way. Here is a link to the KB article on Rank & Window if you aren't familiar with it.

    https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/03ETL_Actions%3A_Rank_and_Window

     




    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.