Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Basic filtering question

Hi,

I am new to qv, can you please help me on this?

I have two tables.

Table A                                       

ID Product

1   A

2   B

3   C

4   D

5   E

6   F

7   G

8   H

9   I

10  J

Table B

ID Product

6   F

7   G

8   H

9   I

10  J

I want to remove the records in Table A those are available in Table B.

How can i achieve this? Exist or not exists function or any other one?

Thanks.

1 Solution

Accepted Solutions
Highlighted
Anonymous
Not applicable

use noconcatenateand drop table B or rename fields otherwise syntetic keys are build

A:

noconcatenate Load *  from A

where not exisits(Product);

View solution in original post

4 Replies
Highlighted
Specialist II
Specialist II

Load table b first then load table a with a where condition like

where not exists(Product);

B:
Load *  from B;

A:

Load *  from A

where not exisits(Product);

-Sundar

Highlighted
Creator II
Creator II

It is giving whole 10 records Bro since it is concatenating.

Highlighted
Anonymous
Not applicable

use noconcatenateand drop table B or rename fields otherwise syntetic keys are build

A:

noconcatenate Load *  from A

where not exisits(Product);

View solution in original post

Highlighted
Not applicable

you can usu noconcatenate