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.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 761 Beast Mode
- 65 App Studio
- 42 Variables
- 703 Automate
- 182 Apps
- 458 APIs & Domo Developer
- 53 Workflows
- 10 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 132 Manage
- 129 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive