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
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.
