topic Re: Error: Load QVD where Field1 in List in QlikView

Error: Load QVD where Field1 in List

QlikUser555 — Sat, 16 Nov 2024 01:42:59 GMT

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.

jaibau1993 — Thu, 12 Dec 2019 07:54:21 GMT

Hi!

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

Regards!

Jaime.

QlikUser555 — Thu, 12 Dec 2019 07:58:22 GMT

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 — Thu, 12 Dec 2019 08:06:08 GMT

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