Looking up values from secondary data source but for multiple columns in primary data source
So I'm having some trouble wrapping my head around a solution for this scenario in Magic ETL:
-I have a primary data source with multiple columns where values are stored in shorthand like "hc_res" but I want to display reports with pretty names like "Healthcare Resources". The mapping of "hc_res" to "Healthcare Resource" exists in a second data source which updates on a pretty regular basis. The issue is that the shorthand names are stored in several columns in the primary data source (i.e. "primary_inquiry_type", "secondary_inquiry_type"), so I need to do the lookup for multiple columns during the ETL.
Normally, I'd use a join to do a lookup for a single column, but I don't think that would work in this scenario unless I did multiple joins - one for each column where the values need to be mapped. Is that my best bet, or is there a better way to achieve this?
I'm also okay replacing the values instead of doing a join if that's possible.
- 10.7K All Categories
- 13 Getting Started in the Community
- 31 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 301 Use Cases & Best Practices
- 500 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- Private Company Board