Left Join
Good morning,
Has anyone else noticed that the left join feature excludes data from the left table if a match is not found on the right table? I have been seening this since the last system update. I have a Table of Active users and one with QA scores. I am using the Active User table as my left table and joining on ADID/Username. I noticed that is a user did not have any QA data for a given period, the left table will exclude theier ADID all together as opposed to keeing the ADID and displaying nulls for the columns coiming from the right table. Please let me know if you are noticing this behavior as well.
Comments
-
Hi,
I have read one article on left join on SQL Data flow, I am not sure if you are looking for the same. Do read below article, see if this helps you:
https://knowledge.domo.com/Prepare/Magic_Transforms/SQL_DataFlows/Optimizing_an_SQL_DataFlow
Do give a like if this helps you.
Thanks,
Neeti
0 -
0
-
I'm experiencing exactly what you've described in my Magic ETL 2.0 flow.
Left Outer Join only keeping matches. Which is incorrect.
1 -
@CR-eSobylak , can you upload a sample dataset? I don't think I've experienced that and I use Magic flows daily.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
I'm using Magic ETL 2.0 and have not seen this happen. Make sure you are not relying on preview to determine if your join is working properly or not. You'll need to run the full dataflow to make sure.
**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
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 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