Skip to content

    • Magic ETL

    Magic ETL

    Mass Alias Column Names

    Member
    in Magic ETL

    I have a dataset with a few hundred columns to alias. Is there a relatively painless way to do this without using the select or alter tile?

    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

    Best Answer

    Answers

    • Coach

      Currently there isn't a simpler way to do this within Magic ETL. You could attempt to utilize MySQL dataflow to programmatically rename the columns if you have a consistent format you want to rename it with.

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

      Thanks. The formatting would be consistent.

    • Coach

      If you drag and hold your mouse over multiple tiles you can choose the Copy to Clipboard option. You can then paste that into any text editor as it is just JSON data. You could then look at the structure of the alter tile and select columns tile to see which would be easier to mass edit outside of Domo and then paste back into your ETL.

      **Check out my Domo Tips & Tricks Videos

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

      Thanks @MarkSnodgrass . I'm using this method and it's going well.

    • Coach
      Answer ✓

      Clever @MarkSnodgrass!

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