If statement help

[priya0709]

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?? 

[ITWhisperer · Accepted solution]

| eval Assignee=case(Support_tier=901 AND HR_Country="Canada","priya",Support_tier=908 OR Support_tier=909,"udit")