Discussion board where members can get started with QlikView.
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:
(ooxml, embedded labels, table is [Records for Inclusion1]);
LOAD Reference,text ([Issue Number]) as [Issue Number],
(ooxml, embedded labels, table is Sheet1)where not exists (Reference);
Why should this be hainging? is it the text conversion in the second table?
Go to Solution.
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.
View solution in original post
Maybe this doesn't depend on this issue but you have to delete the last comma after [Finding],
let me know
Ok thanks, I just cut down the load statement in table 2 to make it easy to read.
What kind of field is reference? Does it contain special characters?
No it would be variations on
GAA IAF 10005184.108.40.206
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?