Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
SELECT
MyNumber,
CASE
WHEN MyNumber = 1 THEN 'One'
WHEN MyNumber = 2 THEN 'Two'
ELSE 'Three or more'
END AS MyText
FROM ...
Using PICK and MATCH functions with a value of TRUE to compare with:
PICK (MATCH (-1, Condition1, Condition 2, -1), Result1, Result2, Default Result)
LOAD
MyNumber,
PICK ( MATCH (-1, MyNumber = 1, MyNumber = 2, -1), 'One', 'Two', 'Three or more') AS MyText
FROM ...
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
1
3
5
4
2
7
9
];
PICK ( WILDMATCH (MyNumber, 1, 2, '*'), 'One','Two','Three or more') AS MyText
PICK ( WILDMATCH (MyNumber, 1, 2, '*'), 'One','Two','Three or more') AS MyText
That makes it easier.
Thank you
could you close the thread? thanks
Sorry I don't know how to close a thread. Please advise
You do so by flagging the correct answer as "Correct Answer".
But for that to be an option, you need to start a question as a question to begin with; you started a discussion.
I have converted it to a question and you can now mark the Correct Answer.
Onno
Community Team member
Ops, I didn't know this (Correct Answer only for question) difference; thanks for the explanation.
Happy I could help and having the rare opportunity to learn a MVP something new .