Load Script 'Where not exists ()'

[tinkerz1]

I am loading 2 tables in the load script, but in the second table I want to show only the results where the refererences do not show in the first.

Qlikview hangs when I try to do this for 2300 lines, my code is:

Table1:

LOAD
Reference
FROM
C:\excel1.xls

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

Table3:

LOAD
Reference,
text ([Issue Number]) as [Issue Number],

Country,
[Finding],
FROM
C:\excel1.xls

(ooxml, embedded labels, table is Sheet1)
where not exists (Reference);

Why should this be hainging? is it the text conversion in the second table?

[alexandros17]

Maybe this doesn't depend on this issue but you have to delete the last comma after [Finding],

let me know

[tinkerz1]

Ok thanks, I just cut down the load statement in table 2 to make it easy to read.

[alexandros17]

What kind of field is reference? Does it contain special characters?

[tinkerz1]

No it would be variations on

GAA IAF 1000512.1.2.1

Nothing special.

[markodonovan · Accepted solution]

Hi Neil,

Can you try renaming the first Reference field to Reference_temp.

Then use a not exists like the following:

WHERE NOT Exists(Reference_temp,Reference);

I have had problems in the past with Not exists not working when used with 1 field but that

was with the AS400 rather than an excel spreadsheet.

Worth a try.

Thanks

Mark

techstuffy.tv

[Digvijay_Singh]

Hi,

As you said, "Qlikview hangs when I try to do this for 2300 lines". So you mean its working below 2300 lines? also do you meant 2300 lines of Sheet1 of Excel1.xls, right?

Thanks,

Digvijay