Discussion Board for collaboration related to QlikView App Development.
I triy to load QVDs with a where in list clause.
Firt of all I load a list with accounts from a csv, with this a selection should be done in a future load statement:
Account as Account_
FROM [Account_list.csv] (txt, utf8, embedded labels, delimiter is ',', msq, filters(Transpose()));
Than I try to load the QVD:
From [2018001.QVD] (qvd);
This works fine, but than I try to load only the Accounts from qvd, wich are in Account_List:
From [2018001.QVD] (qvd) where Match(Account, Account_);
When I reload the script I get a this error:
Field not found error
Field 'Account_' not found
So it seems to be that the load statement can't finde 'Account_', I tried to do everything like it is done in the documentation.
You need to use "Exists" function. Try with: where Exists(Account_,Account).
View solution in original post
Important to mention, is that the first Value is the from the list and the second one is from qvd.
Tried it bevore but like this:
Exits (Account, Account_)
this leads to the same error.
Yes, it confused me too till I got used! 😄