Discussion Board for collaboration on QlikView Scripting.
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:
@1 as cunumber,
@2 as name
@1 as cunumber;
from invoice.txt where exists(Customer_Read,cunumber);
Go to Solution.
Hi try below
from invoice.txt where exists(cunumber,@1);