topic Re: How to get matching data only in QlikView

How to get matching data only

Wed, 04 Feb 2015 09:13:22 GMT

Hi Friends,

I have a big table with lot of columns with one key. For example 140,142,143,145,146 etc.

I have another table with the few keys for example 140,142.

Now I want to fetch all data from big table for only matching values for the above example 140 and 142 only.

Thanks

alexandros17 — Wed, 04 Feb 2015 09:15:30 GMT

Let's say TableA with all values and TableB with less values:

Load * resident TableA;

inner join

Load * resident TableB;

in this way only elements from table B that are Presente in tableA will be shown

Let me know

robert_mika — Wed, 04 Feb 2015 09:15:56 GMT

Look here

or look for ApplyMap

post our data

PrashantSangle — Wed, 04 Feb 2015 09:17:50 GMT

Hi,

There is Various ways

1)Load Table with few Keys then Use left join and load another table having lots of columns

2) use Exist()

1st load table having few Keys, then load 2nd table having lots of column and use where condition in that use Exist()

Regards

MayilVahanan — Wed, 04 Feb 2015 09:39:53 GMT

You can try like this

First load the "second table contains 140,142".

Then use

Left Keep(Secondtable)

Load * from big table;

Hope it helps