topic Re: SQL and Qlikview Script for unmatched records in a left join in QlikView

SQL and Qlikview Script for unmatched records in a left join

tinkerz1 — Wed, 26 Aug 2015 13:58:29 GMT

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]);

Re: SQL and Qlikview Script for unmatched records in a left join

Anonymous — Wed, 26 Aug 2015 14:52:31 GMT

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

Re: SQL and Qlikview Script for unmatched records in a left join

tinkerz1 — Wed, 26 Aug 2015 15:00:25 GMT

Thanks but I was after a tabel of unmatched records in