SQL and Qlikview Script for unmatched records in a left join

[tinkerz1]

Hi,

I am stuck on this; can some one please help with the script to return umatched records on a left join using qlikview and SQL statements.

If I see them both it will help me learn joins.

Thanks,

[Excluded Records]:

LOAD
Reference,
[Report Number],
FROM

(ooxml, embedded labels, table is Sheet1);
left join('Excluded Records')
LOAD
Reference,
[Report Number],
FROM

(ooxml, embedded labels, table is [Records for Exclusion]);

[Anonymous]

hi 

try  this

[Excluded Records]:

LOAD

Reference,

[Report Number],

FROM

(ooxml, embedded labels, table is Sheet1);

left join([Excluded Records])

LOAD

Reference,

[Report Number],

FROM

(ooxml, embedded labels, table is [Records for Exclusion]);

I also attached a link , it might help  you to understand better:

https://www.resultdata.com/using-joins-in-qlikview/

Regards

[tinkerz1]

Thanks but I was after a tabel of unmatched records in