topic Re: Find separate values in two tables in QlikView

Find separate values in two tables

Wed, 03 Dec 2014 08:14:38 GMT

Hi everybody,

I hope that you can help me, here is my question:

I have two tables , for example:

table1: table2:

a.csv a.csv

b.csv d.csv

c.csv e.csv

How can I extract from the table two only the values that are Not in table1?

I will be very appreciated if somebody knows how to do it.

ps: maybe you know a good book about qlikview?

Re: Find separate values in two tables

MK_QSL — Wed, 03 Dec 2014 08:16:45 GMT

Load

a.csv,

b.csv,

c.csv

from.....

load

a.csv,

b.csv,

c.csv

from...

where not exists(a.csv);

Re: Find separate values in two tables

kushalthakral — Wed, 03 Dec 2014 08:21:04 GMT

Hi Ira

u can simply write below script and your problem will be resolved

Table1:

Load

a.csv,

b.csv,

c.csv

from.....

right join(Table1)

load

a.csv,

b.csv,

c.csv

from...

Regards

Kushal Thakral

PS: About book i have a one tell me ur email id will send it to you.

Re: Find separate values in two tables

its_anandrjs — Wed, 03 Dec 2014 08:24:08 GMT

Hi,

Try to load with Key fields assume this example

Tab1:

Load *,ID From a.csv;

concatenate(Tab1)

Load *,ID From b.csv;

concatenate(Tab1)

Load *,ID From c.csv;

tmpTab2:

Load *,ID2 From a.csv;

concatenate(Tab2)

Load *,ID2 From d.csv;

concatenate(Tab2)

Load *,ID2 From e.csv;

Noconcatenate

FinalTable:

Load *,ID2 resident tmpTab2

Where Not Exists(ID,ID2);

Drop table tmpTab2;

Drop Table Tab1;

And read this post may help you

Re: Regarding Exist() function and it's functionality

Regards

Anand

Re: Find separate values in two tables

Fri, 05 Dec 2014 16:16:37 GMT

Thank you very much guys!! each answer is very important for me