Field not found using Exists()

LoKi_asterix — Fri, 15 Nov 2024 20:56:15 GMT

Why am I encountering a "%KYCIDLookUp2 field not found" error in these lines of script?

LookUp: LOAD ID as %KYCIDLookUp2, FROM abc; Temp: LOAD ID as %KeyID, If(not Exists(KYC_ID,%KYCIDLookUp2) and IsNull(DATE_OF_BIRTH),Dual('Not captured',1), If(Age(Today(),DATE(FLOOR(DATE_OF_BIRTH),'DD/MM/YYYY')) < 20,Dual('Below 20',2), If(Age(Today(),DATE(FLOOR(DATE_OF_BIRTH),'DD/MM/YYYY')) >= 20 and Age(Today(),DATE(FLOOR(DATE_OF_BIRTH),'DD/MM/YYYY')) < 30,Dual('20-29',3), If(Age(Today(),DATE(FLOOR(DATE_OF_BIRTH),'DD/MM/YYYY')) >= 30 and Age(Today(),DATE(FLOOR(DATE_OF_BIRTH),'DD/MM/YYYY')) < 40,Dual('30-39',4), If(Age(Today(),DATE(FLOOR(DATE_OF_BIRTH),'DD/MM/YYYY')) >= 40 and Age(Today(),DATE(FLOOR(DATE_OF_BIRTH),'DD/MM/YYYY')) < 50,Dual('40-49',5), If(Age(Today(),DATE(FLOOR(DATE_OF_BIRTH),'DD/MM/YYYY')) >= 50 and Age(Today(),DATE(FLOOR(DATE_OF_BIRTH),'DD/MM/YYYY')) <= 54,Dual('50-54',6), If(Age(Today(),DATE(FLOOR(DATE_OF_BIRTH),'DD/MM/YYYY')) >= 55 and Age(Today(),DATE(FLOOR(DATE_OF_BIRTH),'DD/MM/YYYY')) <= 59,Dual('55-59',7), If(Age(Today(),DATE(FLOOR(DATE_OF_BIRTH),'DD/MM/YYYY')) >= 60,Dual('60 and Above',8),)))))))) as [Age Bucket] FROM xyz;

Re: Field not found using Exists()

igoralcantara — Fri, 21 Jun 2024 12:39:21 GMT

In that case is because that field does not exist in the current table, the table where the Exists expression is.

You might want to reverse the order of parameters in your Exists clause. The first one is the one that looks for previously loaded values.

topic Re: Field not found using Exists() in App Development

Field not found using Exists()

Re: Field not found using Exists()