Is there a way to have a dataset sorted alphabetically?

NathanDorsch
NathanDorsch
in Magic ETL

I have several datasets that have over a hundred columns... and I'd like to have them sorted in alphabetical order. Is there an easy way to do this without having to go through and manually adjust their order using Select Columns in an ETL?

Answers

  • GrantSmith
    GrantSmith Coach

    Not within Magic ETL however, you could possibly utilize MySQL dataflow to query all of the columns in the table via the information_schema, sort them alphabetically and then build your select clause to then select those columns in your dataset.

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

Categories