Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
aschmeelk
New Contributor III

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

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!

1 Reply
balabhaskarqlik
Honored Contributor

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

The Where condition is wrong.

Try:

Where ASSOCIATED_TO = CUSTOMER_INFO_SETTINGS_KEY;