Joins

shreyanshv6
Level 1
Joins

Hi, I wish to do an inner join on two tables. However I also want to save the unmatched rows in a different file. I am not able to find the way to save unmatched columns from an inner join (Without code). Kindly Help with the issue.

Version 11.0.3

0 Kudos
1 Reply
AshleyW
Dataiker

Hi @shreyanshv6 ,

 

Check out this Community discussion that walks you through a few options as to how to create a dataset with unmatched rows from a Join: https://community.dataiku.com/t5/Using-Dataiku/How-do-I-check-unjoined-left-right-records/m-p/31937/...

 

Cheers,

Ashley

 

0 Kudos