Where Not Exists and qualify

Anonymous — Tue, 13 Dec 2016 18:35:57 GMT

Hello,

I am unsuccessful in combining Not Exists and qualify/unqualify.

Goal: load a dataset and identify lines that have one field (or combinaton of fields) in common with previously loaded lines; in that case either not load the line (what I try to do here) or as an alternative load the line with a special flag telling it is a "duplicate".

If I do this :

table1:

LOAD

FROM

file.txt

(...)

where

not exists(a);

It works fine, I have no duplicate lines for field a.

If I do this:

qualify*;

table1:

LOAD

FROM

file.txt

(...)

where

not exists(a);

unqualify;

It doesn't work, I get an empty table.

If I do this :

qualify*;

table1:

LOAD

FROM

file.txt

(...)

where

not exists(table1.a);

unqualify;

It doesn't work, I get an error message from the load telling the field table1.a cannot be found.

Any idea on how to solve this?.

Re: Where Not Exists and qualify

sunny_talwar — Tue, 13 Dec 2016 18:48:43 GMT

May be like this:

qualify *;

UNQUALIFY a;

table1:

LOAD * Inline [

a, b

A, 10

A, 20

A, 30

]

Where not exists(a);

unqualify *;

RENAME Field a to table1.a;

Re: Where Not Exists and qualify

Anonymous — Wed, 14 Dec 2016 11:11:55 GMT

Thank you, this works.

topic Re: Where Not Exists and qualify in QlikView

Where Not Exists and qualify

Re: Where Not Exists and qualify

Re: Where Not Exists and qualify