ETL join is matching multiple values - not exact matches
I am joining two datasets and the result is matching multiple values from the second data set to a single value in the first data set. Is it possible to have the join only match exact values?
Example:
Data Set 1
Data Set 2
Join result
Join = Left Outer
- Left Table = Data Set 1
- Right Table = Data Set 2
- Matching Column = ID
- Renaming second ID column
Answers
-
I have not seen that happen before. In fact, the Magic ETL joins tend to be very exact, including be case-sensitive. I would try making a new ETL and trying to do the join again.
Also, to be clear, LEFT JOIN will include all records from the left table and any matching entries from the right table. INNER JOIN will only include records where there is a match in both tables.
**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.2 -
Thanks Mark.
I do want all data from the left table and to only provide exact matching data from the right table so the left join is correct in my situation. I will create a copy and test.
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 303 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 763 Beast Mode
- 65 App Studio
- 42 Variables
- 709 Automate
- 184 Apps
- 460 APIs & Domo Developer
- 54 Workflows
- 11 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 134 Manage
- 131 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive