Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Friend
Set Analysis is only available to aggr expressions in expressions in charts, are not available to load script sentences
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;