Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to get matching data only

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

Tags (1)
1 Solution

Accepted Solutions

Re: How to get matching data only

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

Regards,
Prashant Sangle
4 Replies

Re: How to get matching data only

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

Re: How to get matching data only

Look here

Duplicate row Issue

or look for ApplyMap

or

post our data

Re: How to get matching data only

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

Regards,
Prashant Sangle

Re: How to get matching data only

HI

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

Community Browser