Additional column with values based on existing column values

anmohan0 — Mon, 10 Feb 2025 09:08:38 GMT

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

Re: Additional column with values based on existing column values

ITWhisperer — Mon, 10 Feb 2025 09:28:46 GMT

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

Re: Additional column with values based on existing column values

anmohan0 — Mon, 10 Feb 2025 12:19:27 GMT

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

topic Additional column with values based on existing column values in Dashboards & Visualizations

Additional column with values based on existing column values

Re: Additional column with values based on existing column values

Re: Additional column with values based on existing column values