Set Expression syntax for the Data Load Editor

[vstone]

I'm trying create a column using set expression syntax in my load statement in the data load editor:

Count(total<br_name>{<compliance_check={'PASS', 'Pass'}>}br_name) as count_compliant

Where br_name, and compliance_check are columns in my database. How would this syntax work in the data load editor? I'm getting syntax errors with that statement.

[marcos_herrera]

Hi Friend

Set Analysis is only available to aggr expressions in expressions in charts, are not available to load script sentences

[lironbaram]

hi 

you can use the total function or set analysis in your script 
this should be translated to something like this 

load br_name,
     count(br_name) as count_compliant
from XXX
where match(compliance_check,'PASS','Pass')
group by br_name;