I would like to add a column called Management to my table. The management value is not part of the event data. It is something I would like to assign based on the value of Applications:
Any help would be appreciated.
| Management | Applications |
| In | IIT |
| In | ALP |
| In | MAL |
| In | HST |
| Out | OCC |
| In | ALY |
| In | GSS |
| In | HHS |
| In | ISD |
| eval Management=if(Applications="OCC", "Out", "In")
@ITWhisperer Thank you so much, it really saved my time.