How to get left unjoined records ?

Question

Hi All,

I have 2 datasets one containing 680248 records and other containing only audit numbers(554 Records).

I used left unjoined  based on the common column in the 2 datasets "Audit Number " & removed 259 records. So when I tap the L output anchor  of the join tool I am able to get 679989 records (680248-259=679989).

.

So, How to retrive (or get) these deleted 259 records and store it in a  .xlsv file?

Please help me to resolve this. Thanks in advance.

DataNath · Answer

Hey @Ganesshh_TL, if you're looking at the difference between the number of records going in the L input and coming out of the L output, then the records you 'lose' will actually be ones that find a match i.e. come out of the J anchor. Therefore, you should look at what comes out of the J anchor in this case to find the records you're after.

Ganesshh_TL · Answer

I used left unjoined  based on the common column in the 2 datasets "Audit Number " & removed 259 records.

when I tap the L output anchor  of the join tool I am able to get 679989 records (680248-259=679989).

.

So, How to retrive (or get) these deleted 259 records and store it in a  .xlsv file?

DataNath · Answer

Hey @Ganesshh_TL, on the Join tool there are 3 output anchors - L, J & R. The J anchor shows all records that find a match, and the L and R anchors show records coming from the left and right inputs that didn't find a match based on the join condition. Therefore, to see these unjoined records from the left input, look in the L (Left) output anchor of the Join tool.