I need to create a case statement in Spotfire please help.
Case WHEN UniqueCount([Product])<5 then UniqueConcatenate([Product]) else "Multipl Products" WHEN UniqueCount([Division])<5 then UniqueConcatenate([Division]) else "Multipl Dev" END
I need to create a case statement in Spotfire please help.
Case WHEN UniqueCount([Product])<5 then UniqueConcatenate([Product]) else "Multipl Products" WHEN UniqueCount([Division])<5 then UniqueConcatenate([Division]) else "Multipl Dev" END
per the documentation, CASE statements are only allowed a single ELSE. also I am assuming based on the provided example that you need two separate columns.
column 1 [Products]:
CASE
WHEN UniqueCount([Product])<5 then UniqueConcatenate([Product])
ELSE "Multiple Products"
END
column 2 [Divisions]:
CASE
WHEN UniqueCount([Division])<5 then UniqueConcatenate([Division])
else "Multiple Divisions"
END
if this doesn't answer, please edit your question for clarity.