topic Re: Exclude ID's from in QlikView

Exclude ID's from

jagdishbr — Wed, 25 Nov 2020 16:16:04 GMT

I'm new to Qlikview and i have struggling to crack this in load statement. Can anyone help me please

QVD1 has below ID's

A_ID Name

1001 A

1002 B

1003 C

1004 D

1005 E

QVD2 has below ID's

A_ID

1003

1005

Need Output from QVD1

A_ID Name

1001 A

1002 B

1004 D

Basically, i need to exclude all the id's exists in QVD2

Re: Exclude ID's from

sergio0592 — Wed, 12 Jul 2017 21:25:05 GMT

Use where not exits.

load * from QVD1.qvd (qvd) ;

load * from QVD2.qvd (qvd) where not exist (A_ID);

Re: Exclude ID's from

Nicole-Smith — Wed, 12 Jul 2017 21:25:53 GMT

QVD2:

LOAD A_ID

FROM QVD2.qvd (qvd);

QVD1:

NOCONCATENATE LOAD A_ID, Name

FROM QVD1.qvd (qvd)

WHERE NOT EXISTS(A_ID);

DROP TABLE QVD2;

Re: Exclude ID's from

vishsaggi — Wed, 12 Jul 2017 21:30:45 GMT

Try this?

Table1:

LOAD * INLINE [

A_ID

1003

1005

] ;

Right JOIN(Table1)

LOAD * INLINE [

A_ID, Name

1001, A

1002, B

1003, C

1004, D

1005, E

]WHERE Not Exists(A_ID, A_ID) ;

Re: Exclude ID's from

jagdishbr — Wed, 12 Jul 2017 21:38:59 GMT

Thank you very much Nicole for your reply. It worked.

Re: Exclude ID's from

jagdishbr — Wed, 12 Jul 2017 21:45:14 GMT

Thanks Vishwarath. it worked as well.