topic Re: Basic filtering question in QlikView

Basic filtering question

raju_salmon — Tue, 22 Dec 2015 07:19:26 GMT

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.

sundarakumar — Tue, 22 Dec 2015 07:21:27 GMT

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

where not exists(Product);

B:
Load * from B;

Load * from A

where not exisits(Product);

-Sundar

raju_salmon — Tue, 22 Dec 2015 07:30:51 GMT

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

Anonymous — Tue, 22 Dec 2015 07:34:45 GMT

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

noconcatenate Load * from A

where not exisits(Product);

Tue, 22 Dec 2015 07:37:13 GMT

you can usu noconcatenate