How to map 1 value into the same row of another column in ETL
Please see attachment. I need to map a value from one column to another.
Context: Marketing's Department ID needs to be the same as its Organization ID. I've tried Value Mapper but it seems like that will only allow me to make a brand new column. I don't want a brand new column.
Please help! Which ETL function should I use?
Best Answer
-
Is the Marketing Department the only department that is missing an Organization ID?
if all the other rows apart from marketing have a value in them, you could just use a replace text to replace any null or blank values with 4410.
otherwise you would need to filter just the marketing values first and then perform the replace text on the organization I’d field.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1
Answers
-
Is the Marketing Department the only department that is missing an Organization ID?
if all the other rows apart from marketing have a value in them, you could just use a replace text to replace any null or blank values with 4410.
otherwise you would need to filter just the marketing values first and then perform the replace text on the organization I’d field.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
Thank you! I ended up doing separate filters for each department that was missing an Organization ID and then using Value Mapper to populate the blank fields. I then appended the rows back together.
I did not use Replace Text because it does not work on numbers.
Thanks!!
0 -
I would encourage you to change the field type of any ID field to a string. Only use values for fields that you want to do calculations on
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
That was such a good trick to filter the rows and re-append! I just had a similar issue and that solved it. Thanks!
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive