Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikUser555
Contributor II
Contributor II

Error: Load QVD where Field1 in List

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.

Labels (2)
1 Solution

Accepted Solutions
jaibau1993
Partner - Creator III
Partner - Creator III

Hi!

You need to use "Exists" function. Try with: where Exists(Account_,Account).

Regards!

Jaime.

View solution in original post

3 Replies
jaibau1993
Partner - Creator III
Partner - Creator III

Hi!

You need to use "Exists" function. Try with: where Exists(Account_,Account).

Regards!

Jaime.

QlikUser555
Contributor II
Contributor II
Author

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.

jaibau1993
Partner - Creator III
Partner - Creator III

Yes, it confused me too till I got used! 😄