How can I find rows in one column that are not in another column

JJ14
JJ14 Member
in Magic ETL

I am using a magic ETL. I have tried using a left join but it returns the rows that are not in the other column and also all the left column rows.

Best Answers

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach

    Can you elaborate a bit more as to what your two datasets look like that you are trying to compare? What does your join criteria look like?

    **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.
  • JJ14
    JJ14 Member

    I have 2 datasets, one has column A, the other has column B. I would like to get rows from column A that are not in column B using magic ETL.

  • MarkSnodgrass
    MarkSnodgrass Coach
    edited December 2023 Answer ✓

    Are column A and column B the same information? For example, a ProductID or something? If so, then you would use a Left Join and have the dataset that has column A on the left side and have your join criteria be Column A - Column B. After the join tile, you can add a filter tile and filter to where column B is null.

    **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.
  • JJ14
    JJ14 Member
    Answer ✓
    https://community-forums.domo.com/main/discussion/comment/84320#Comment_84320

    Thanks it works!

Categories