Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am aware that Pick Match can be a better way of writing an IF expression.
However, what is a better way to write an IF expression if the expression has an ELSE in the code too?
What is the expression? You can write Pick(Match()) in case of else as well....
You're probably going to want to be more specific about your use case. If/Else can be substituted for things like Match, and multiple ApplyMaps depending on how exotic you want to get.
One way could be to wrap a pick(match()) within an if-loop to fetch the else-part or if your results are only numeric you could use alt(pick(match()), ElsePart).
Another possibility might be to use an else-part within the pick(match()) maybe in this way:
pick(wildmatch(Field, 'a', 'b', '*'), 'a', 'b', 'else')
- Marcus