load *,subfield(IssueTmp,',') as IssueTmp2;
LOAD *,if([Issue Type]='See Alert Name',[Alert Name],[Issue Type]) as IssueTmp INLINE [
ID, Alert Name, Issue Type
1, Danger, A
2, Warning, See Alert Name
3, Review, "T,R,Y"
4, Warning, See Alert Name
5, Danger, C
6, Check, N
7, Review, "F,R"
load IssueTmp2 as Error,count(IssueTmp2) as NbrError resident Data group by IssueTmp2;
drop table Data;
Regards, Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
Thanks for your answer Taoufiq. Is there any way to do this on the front end with a formula? I'll be passing off this work to a team that really doesn't have any experience using the back end, so it's discouraged for me to hand them solutions in the script.