topic Re: Loading a table if customer exists in another table in QlikView

Loading a table if customer exists in another table

Tue, 06 May 2014 09:49:09 GMT

Hello,

how do I only load data into table Invoice for customers that exists in table Customer_Read.

The field cunumber exists in both tables. The code below gives an empty table Invoice:

Customer_Read:

Load

@1 as cunumber,

@2 as name

from customer.txt;

Invoice:

Load

@1 as cunumber;

.

.

from invoice.txt where exists(Customer_Read,cunumber);

kindly

Håkan

Re: Loading a table if customer exists in another table

ashfaq_haseeb — Tue, 06 May 2014 09:53:50 GMT

Hi try below

Customer_Read:

Load

@1 as cunumber,

@2 as name

from customer.txt;

Invoice:

Load

@1 as cunumber;

.

.

from invoice.txt where exists(cunumber,@1);

Regards

ASHFAQ