How can I load only those customers whose ID is in the first table?

[#1]

I have loaded the table which includes customers, they ID numbers and more information. I have the QVD file, where is another information about customers, there is same customers (same ID number) as in the first table and others, which I don't need.

How can I load only those customers to second table whose ID is in the first table?

[kaushiknsolanki]

Hi,

   Have a look at the below link.

   http://qlikviewmaven.blogspot.com/2009/01/qlikview-exists-function.html

   Hope this helps.

Regards,

Kaushik Solanki

[lironbaram]

hei  two options:

1. load the first table with the Customer you want

then load the second table  like

load *

from SecondTble

where exists(CutomerID);

2. load the first table and then write

leftjoin(tab1)

Load *

from  SecondTble

[#4]

Thanks, it helped