Replacing Values in Multiple Columns Based on a Lookup Table
So here's a challenge I can't seem to figure out how to solve in Magic ETL. I have a primary data source that has values written out as "tags" like "hc_res" and a secondary data source that maps those tables to pretty display names like "Healthcare Resources," which is what I need to display in reports. Normally, I'd just do a join to map these together, however my primary database has these values in multiple columns that need to use the same lookups. So for instance there is a column called "primary_inquiry_type" which might have "hc_res" in it, but there is another column called "secondary_inquiry_type" which also might have the value in it, and so forth.
Is there a way I can either do a replace operation on the tags across the board with the pretty display names in the secondary data source, or at least create additional columns for each one? Is my best solution to do multiple joins to the same lookup data source, or is there a better solution?
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive