Left Join

user058839
user058839 Member
edited March 2023 in Datasets

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

  • Jarvis
    Jarvis Domo Employee

    Hi there,

     

    This is not something I have seen in the dataflows myself but I'm sure its something support would want to know about. I would reach out directly to support and have them look at your dataflow directly.

    Best Regards

    Jarvis

  • Neeti
    Neeti Member

    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

  • CR-eSobylak
    CR-eSobylak Member
  • CR-eSobylak
    CR-eSobylak Member

    I'm experiencing exactly what you've described in my Magic ETL 2.0 flow.

    Left Outer Join only keeping matches. Which is incorrect. 

  • jaeW_at_Onyx
    jaeW_at_Onyx Coach

    @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"
  • MarkSnodgrass
    MarkSnodgrass Coach

    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 <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories