Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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