Additional column with values based on existing column values

[anmohan0]

Hi,

I am displaying a table as a result from the Search, however I would like to add an additional column with static values based on the existing column. For example,

S.No    Name    Dept

1          Andy      IT

2          Chris      Bus

3          Nike        Pay

In the above table, I would like to add another column called Company and map value based on Dept column as below
If Dept is IT, then the value for Company as XXXX

If Dept is Bus, then the value for Company is YYYY

If Dept is Pay, then the value for Company is ZZZZ and the final table should look like

S.No    Name    Dept    Comp

1          Andy      IT           XXXX

2          Chris      Bus       YYYY

3          Nike        Pay       ZZZZ

@ITWhisperer Dashboard 

[anmohan0]

Thanks for the quick help and it did save my day!

[ITWhisperer · Accepted solution]

| eval Comp=case(Dept=="IT","XXXX",Dept=="Bus","YYYY",Dept=="Pay","ZZZZ")