topic Re: Load Script 'Where not exists ()' in QlikView

Load Script 'Where not exists ()'

tinkerz1 — Wed, 02 Sep 2015 10:02:44 GMT

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?

Re: Load Script 'Where not exists ()'

alexandros17 — Wed, 02 Sep 2015 10:07:01 GMT

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

let me know

Re: Load Script 'Where not exists ()'

tinkerz1 — Wed, 02 Sep 2015 10:18:02 GMT

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

Re: Load Script 'Where not exists ()'

alexandros17 — Wed, 02 Sep 2015 10:25:05 GMT

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

Re: Load Script 'Where not exists ()'

tinkerz1 — Wed, 02 Sep 2015 10:29:37 GMT

No it would be variations on

GAA IAF 1000512.1.2.1

Nothing special.

Re: Load Script 'Where not exists ()'

markodonovan — Wed, 02 Sep 2015 10:38:53 GMT

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

Re: Load Script 'Where not exists ()'

Digvijay_Singh — Wed, 02 Sep 2015 10:46:30 GMT

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