Magic ETL column parsing

renee12345
renee12345 Member
in Magic ETL

Is there an easy way using Magic ETL to create new columns based on existing columns. For example I have an ID column and a Page Name column and want to make each ID and Page Name a net new column to link to other data in the dataset. (I'm using governance Page data)

Any ideas here?

Tagged:

Answers

  • GrantSmith
    GrantSmith Coach

    You can use the split columns tile in magic ETL or utilize a formula tile with a regexp_replace or split_part function depending on how your field is formatted. Do you have an example of what your data looks like?

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

    It sounds like you are wanting to combine two columns together to make a new unique ID. You can do this with the formula tile and use the CONCAT function. Something like this:

    CONCAT(IDcolumn,'-',PageColumn) This would combine the two columns with a hyphen between the two fields.

    **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.
  • renee12345
    renee12345 Member
    Screenshot 2023-11-30 at 1.32.10 PM.png

    I am joining in viewership data with this, so Ideally the Parent Page Title, Finance, will be it's own column along with the Parent Page ID, that way the Other Page Titles and IDs will be bucketed underneath, if that makes sense, so I can visualize each Parent Page as the series with the view count of these pages

Categories