Find unmatched record

[Rajitha1]

How to find unmatched records from two tables without using joins

[BrunPierre · Accepted solution]

As shown below

T1_Temp:
LOAD *,
Ticketno&'|'&source&'|'&destination&'|'&[time(Hrs)] as %KeyT1;
LOAD Ticketno, 
     source, 
     destination, 
     [time(Hrs)]

FROM TableSource;

NoConcatenate
T2_Temp:
LOAD *,
Ticketno&'|'&source&'|'&destination&'|'&[time(Hrs)] as %KeyT2;

LOAD Ticketno, 
     source, 
     destination, 
     [time(Hrs)]

FROM Table2Source;

UnmatchedRecords:
Load Ticketno,
     source,
     destination,
     [time(Hrs)]
     
Resident T1_Temp
Where exists(%KeyT2,%KeyT1)=0;
DROP Table T1_Temp,T2_Temp;

EXIT SCRIPT;