I have a table generating fields Assignee, Support_tier, HR_Country, Hostdomain,
I have to Assign some values to 'Assignee' based on some values in other fields
Eg: if Support_tier is 901 and HR_Country is Canada the Assignee value should be 'priya' also if Support_tier is 908 & 909 Assignee should be 'udit'
Kindly help with the query??
| eval Assignee=case(Support_tier=901 AND HR_Country="Canada","priya",Support_tier=908 OR Support_tier=909,"udit")
| eval Assignee=case(Support_tier=901 AND HR_Country="Canada","priya",Support_tier=908 OR Support_tier=909,"udit")