Mass Alias Column Names

Sam_Y
Sam_Y 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?

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Clever @MarkSnodgrass!

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

Answers

  • GrantSmith
    GrantSmith 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!**
  • Sam_Y
    Sam_Y Member

    Thanks. The formatting would be consistent.

  • MarkSnodgrass
    MarkSnodgrass 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.
  • Sam_Y
    Sam_Y Member

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

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Clever @MarkSnodgrass!

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

Categories