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: 
aschmeelk
Contributor III
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

The Where condition is wrong.

Try:

Where ASSOCIATED_TO = CUSTOMER_INFO_SETTINGS_KEY;