Are there any function like switch case?

[#1]

Hi,

I was wondering whether there are some function like switch case.

Allow me to take an example:

In the expression: I can use If clause to judge, but it is limited to 2 choices, but I want to get more than 2 choices.

Thanks.

[deepakk]

hi,

You can use the Match function to achieve the same

eg:

if(match( Year, 2000,2001,2002)>0,1)

I hope this helps.

[#3]

I mean, I want this one:

If year=2000 then A , year=2001 then B, year=2002 then C.

How to do?

[#4 · Accepted solution]

Hi Isaac,

Check if below code helps you.

pick(wildmatch(Year,2000, 2001,2002,'*'),'A', 'B', 'C', 'Other')

- Sridhar