Joins
shreyanshv6
Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 6 ✭
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
Answers
-
Ashley Dataiker, Alpha Tester, Dataiku DSS Core Designer, Registered, Product Ideas Manager Posts: 161 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/highlight/true#M11830
Cheers,
Ashley