This content has been marked as final. Show 7 replies
WHEN MyNumber = 1 THEN 'One'
WHEN MyNumber = 2 THEN 'Two'
ELSE 'Three or more'
END AS MyText
Using PICK and MATCH functions with a value of TRUE to compare with:
PICK (MATCH (-1, Condition1, Condition 2, -1), Result1, Result2, Default Result)
PICK ( MATCH (-1, MyNumber = 1, MyNumber = 2, -1), 'One', 'Two', 'Three or more') AS MyText
Please let me know your opinion about it, or if you have a better way for writing that.
If you want to check, just copy and paste the following:
LOAD *, PICK ( MATCH (-1, MyNumber = 1, MyNumber = 2, -1), 'One','Two','Three or more') AS MyText;
LOAD * INLINE [MyNumber