Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Exclude data from table load script

Hi

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

Exclusions.png

Tags (1)
5 Replies
MVP
MVP

Re: Exclude data from table load script

May be this:

TableB:

LOAD KeyFields

FROM B.qvd;

TableA:

LOAD KeyFields,

          OtherFieldNames

FROM A.qvd

Where not Exists(KeyFields);


DROP Table TableB;

Not applicable

Re: Exclude data from table load script

Thanks It work

MVP
MVP

Re: Exclude data from table load script

Great

mercedes_cobas
New Contributor

Re: Exclude data from table load script

Hi Sunny, thanks for the explanation.

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

ID#Doc#
1333
1444
1555
2333
2444
3333
3555

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

MVP
MVP

Re: Exclude data from table load script

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#;

Community Browser