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

JJ14

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.

MarkSnodgrass

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.

JJ14

https://community-forums.domo.com/main/discussion/comment/84320#Comment_84320

Thanks it works!

MarkSnodgrass

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?

JJ14

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

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.

JJ14

https://community-forums.domo.com/main/discussion/comment/84320#Comment_84320

Thanks it works!