Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
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_List:
Load
Account as Account_
FROM [Account_list.csv] (txt, utf8, embedded labels, delimiter is ',', msq, filters(Transpose()
));
Than I try to load the QVD:
QVD_Load:
Load
Date,
Account,
xyz
From [2018001.QVD] (qvd);
This works fine, but than I try to load only the Accounts from qvd, wich are in Account_List:
Load
Date,
Account,
xyz
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.
Hi!
You need to use "Exists" function. Try with: where Exists(Account_,Account).
Regards!
Jaime.
Hi!
You need to use "Exists" function. Try with: where Exists(Account_,Account).
Regards!
Jaime.
Thanks,
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! 😄