Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Loading a table if customer exists in another table

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

1 Solution

Accepted Solutions

Re: Loading a table if customer exists in another table

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

1 Reply

Re: Loading a table if customer exists in another table

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

Community Browser