Magic ETL column parsing
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?
Answers
-
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!**0 -
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 any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
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
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 293 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 96 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 705 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive