Why am I getting 'Field 'ADC_KEY' not found' in the following code?

aschmeelk — Wed, 27 Jun 2018 15:07:05 GMT

Code:

gra_customer_info_settings:

LOAD *

FROM [lib://Snider - QVDs (win000294_aschmeelk)/gra_customer_info_Settings.qvd]

(qvd);

Left Join (gra_customer_info_settings)

Load

[Customer Code] AS ADC_CODE,

[Customer Name] AS ADC_NAME,

ASSOCIATED_TO AS ADC_KEY

Resident gra_customer_info_settings

Where ADC_KEY = CUSTOMER_INFO_SETTINGS_KEY;

I get this error whether I prepend the table name to the field or not.

I am missing something, but what? I have searched through the community for an answer to this, but so far, haven't found any answers.

Any/all help will be greatly appreciated!

Re: Why am I getting 'Field 'ADC_KEY' not found' in the following code?

BalaBhaskar_Qlik — Wed, 27 Jun 2018 18:25:36 GMT

The Where condition is wrong.

Try:

Where ASSOCIATED_TO = CUSTOMER_INFO_SETTINGS_KEY;