topic Re: Exclude data from table load script in QlikView

Exclude data from table load script

Tue, 05 Jan 2016 14:53:58 GMT

I have table A and table B loaded from QVD and I want just to stay with the values that just appear in A and not in B

sunny_talwar — Tue, 05 Jan 2016 16:34:50 GMT

May be this:

TableB:

LOAD KeyFields

FROM B.qvd;

TableA:

LOAD KeyFields,

OtherFieldNames

FROM A.qvd

Where not Exists(KeyFields);

DROP Table TableB;

Tue, 05 Jan 2016 16:42:02 GMT

Thanks It work

sunny_talwar — Tue, 05 Jan 2016 17:26:04 GMT

Great

Anonymous — Fri, 24 Mar 2017 16:00:52 GMT

Hi Sunny, thanks for the explanation.

I would like to know how should I do if I have the following fields:

So I want to exclude all ID# that has Doc#555.

And result shoud be a table with ID#2

Is there any way to achieve it?

Thanks

sunny_talwar — Sat, 25 Mar 2017 11:50:46 GMT

You can try like this:

Table:

LOAD ID#,

Doc#

FROM ....;

Right Join (Table)

LOAD ID#

Where Count = 0;

LOAD ID#,

Count(If(Doc# = 555, Doc#)) as Count

Resident Table

Group By ID#;