Issue Joining Datasets using Magic ETL Left Outer Join
Hello, I am trying to join two datasets one is a huge datasets that has all employee numbers in the company and the other one is another dataset that has a list of different case numbers and a requester employee number that I am trying to validate the employee number and the their tiers using the bigger employee dataset by join the requester number column and the employee numbers column from the employee dataset. Whenever I try to join using left outer. it is not recognizing the and linking between the two columns
Best Answer
-
It's hard to know what the issue might be without seeing screenshots of the flow. One thing that comes to mind, though, is to make sure that the fields you're joining on are of the same type. If they don't match, you can change a field's data type in the input tile's Configuration > Data Handling.
0
Answers
-
can you show examples of what you are doing and what error you are getting?
0 -
It's hard to know what the issue might be without seeing screenshots of the flow. One thing that comes to mind, though, is to make sure that the fields you're joining on are of the same type. If they don't match, you can change a field's data type in the input tile's Configuration > Data Handling.
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 310 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 114 SQL DataFlows
- 654 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 797 Beast Mode
- 78 App Studio
- 44 Variables
- 757 Automate
- 188 Apps
- 480 APIs & Domo Developer
- 72 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive