Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

tinkerz1
Contributor II

Load Script 'Where not exists ()'


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?

1 Solution

Accepted Solutions
markodonovan
Valued Contributor

Re: Load Script 'Where not exists ()'

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

View solution in original post

6 Replies

Re: Load Script 'Where not exists ()'

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

let me know

tinkerz1
Contributor II

Re: Load Script 'Where not exists ()'

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

Re: Load Script 'Where not exists ()'

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

tinkerz1
Contributor II

Re: Load Script 'Where not exists ()'

No it would be variations on

GAA IAF 1000512.1.2.1

Nothing special.


markodonovan
Valued Contributor

Re: Load Script 'Where not exists ()'

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

View solution in original post

Digvijay_Singh
Honored Contributor III

Re: Load Script 'Where not exists ()'

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