Exclude ID's from

[jagdishbr]

Hi

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

[sergio0592]

Use where not exits.

load * from QVD1.qvd (qvd) ;

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

[Nicole-Smith]

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;

[vishsaggi]

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

[jagdishbr]

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

[jagdishbr]

Thanks Vishwarath. it worked as well.