I am trying to execute the below query in a query activity. The intent is to find how many emails a customer record have. The query is executing without errors but the
No_Of_Email column is not getting populated.
Could anyone see any obvious errors.
Thanks for your help on this.
SELECT ((CASE WHEN email1_TXT ='' THEN 0 ELSE 1 END)+ (CASE WHEN email2_TXT ='' THEN 0 ELSE 1 END)+ (CASE WHEN email3_TXT ='' THEN 0 ELSE 1 END)) as No_Of_Email ,Customer_ID FROM Customer