Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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

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?

3 Replies
kaushik_solanki
Not applicable

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

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
Not applicable

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

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

Not applicable

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

Thanks, it helped