hello everyone,
Need help with the query below, I want to compute the fields that are empty and score that record based on the number of empty fields in the object.
"q = load "Account_hygiene";
q = group q by rollup('Name','Website','ZI_Website__c');
q = foreach q generate
(case
when grouping('Website') == null then "1"
else "0"
end) as 'Website',
(case
when grouping('ZI_Website__c') == null then "1"
else "0"
end) as 'ZI_Website__c',
sum('Amount') as 'sum_Amount';"
Error Message: Undefined identifier: "Amount". Make sure the "Amount" identifier exists and is spelled correctly without spaces
Thanks @Ravendra Shukla I am facing this error now:
Syntax Error at position [line 15: column 34] after token = :: fields_count = 0 then 100
