https://community.splunk.com/t5/Splunk-Search/If-statement-help/m-p/520182#M146480 <LI-CODE lang="markup">| eval Assignee=case(Support_tier=901 AND HR_Country="Canada","priya",Support_tier=908 OR Support_tier=909,"udit")</LI-CODE> Thu, 17 Sep 2020 16:49:40 GMT ITWhisperer 2020-09-17T16:49:40Z https://community.splunk.com/t5/Splunk-Search/If-statement-help/m-p/520178#M146479 <P>I have a table generating fields Assignee, Support_tier, HR_Country, Hostdomain,</P><P>I have to Assign some values to 'Assignee' based on some values in other fields</P><P>Eg:&nbsp; if Support_tier is 901 and HR_Country is Canada the Assignee value should be 'priya'&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; also if Support_tier is 908 &amp; 909 Assignee should be 'udit'&nbsp;&nbsp;</P><P>Kindly help with the query??&nbsp;</P> Thu, 17 Sep 2020 16:37:27 GMT https://community.splunk.com/t5/Splunk-Search/If-statement-help/m-p/520178#M146479 priya0709 2020-09-17T16:37:27Z https://community.splunk.com/t5/Splunk-Search/If-statement-help/m-p/520182#M146480 <LI-CODE lang="markup">| eval Assignee=case(Support_tier=901 AND HR_Country="Canada","priya",Support_tier=908 OR Support_tier=909,"udit")</LI-CODE> Thu, 17 Sep 2020 16:49:40 GMT https://community.splunk.com/t5/Splunk-Search/If-statement-help/m-p/520182#M146480 ITWhisperer 2020-09-17T16:49:40Z