Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a column with numbers ranging from 1 to 15, I want to create a flag such as if number is 1 - Primary if the number is 2 and greater secondary into a new column, please advise thank you
IF([Number Column]='1','Primary',
IF([Number Column]>'1','Secondary',NULL())) AS [New Column]
That statement should be in the script, then perhaps the resultant field i.e. [Primary/Secondary] will be used as a dimension against an expression like Count(distinct DiagnosisCD ).
I hope this helps or better yet share what you want to achieve.