How get and combined column from another dataset using magicETL
Dataset A columns: Name, Bday, Age, Gender, City Address, Country
Dataset B columns: Name, Position, Salary, Company
columns I only want and will name as DatasetC: Name, Bday, Age, Position, Salary
I am thinking if I can just use Dataset B, save as Dataset C and add columns (Name, Bday, Age) from Dataset A. But I don't know how. Please help.
Thank you!
Best Answers
-
You will need to join the datasets on Name. Name is not a great join key. If you have a unique ID that would be better. Also when joining it would probably be good to ensure that case matches by using LOWER() function on Name in both datasets. Again, name is not a great join key, so if there are other options use those. If you provide some sample data I can show you what the dataflow would look like in Magic ETL.
I walked through how to do this here:
If I solved your problem, please select "yes" above
0 -
I walked through how to do this here:
If I solved your problem, please select "yes" above
0
Answers
-
You will need to join the datasets on Name. Name is not a great join key. If you have a unique ID that would be better. Also when joining it would probably be good to ensure that case matches by using LOWER() function on Name in both datasets. Again, name is not a great join key, so if there are other options use those. If you provide some sample data I can show you what the dataflow would look like in Magic ETL.
I walked through how to do this here:
If I solved your problem, please select "yes" above
0 -
I walked through how to do this here:
If I solved your problem, please select "yes" above
0 -
This works! Thanks a lot coach @ColemenWilson
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive