Loading a table if customer exists in another table

[#1]

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

[ashfaq_haseeb · Accepted solution]

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