https://community.splunk.com/t5/Splunk-Search/Help-with-Field-Extraction-How-draft-the-if-condition-to-achieve/m-p/608681#M211652 <P>Try this</P><LI-CODE lang="markup">user = coalesce(cmdid, userid, "unknown")</LI-CODE> Mon, 08 Aug 2022 12:15:41 GMT richgalloway 2022-08-08T12:15:41Z https://community.splunk.com/t5/Splunk-Search/Help-with-Field-Extraction-How-draft-the-if-condition-to-achieve/m-p/608676#M211650 <P>I want to do a field extraction for my sourcetype under the Fields-&gt; Calculated Fields section. Confused how to draft the if condition to achieve the following logic.<BR /><BR /><U>Condition.</U><BR />Some events contain&nbsp; only the userid field, for those, check if it is not null/empty, then fetch the userid field as user or fill unknown<BR />Some events contain both userid and cmdid field, in this case (if the event has both these fields) cmdid is the real user field. so the logic in both cases should first compare the existence of those 2 fields and then accordingly derive.</P> Tue, 09 Aug 2022 14:16:47 GMT https://community.splunk.com/t5/Splunk-Search/Help-with-Field-Extraction-How-draft-the-if-condition-to-achieve/m-p/608676#M211650 zacksoft_wf 2022-08-09T14:16:47Z https://community.splunk.com/t5/Splunk-Search/Help-with-Field-Extraction-How-draft-the-if-condition-to-achieve/m-p/608681#M211652 <P>Try this</P><LI-CODE lang="markup">user = coalesce(cmdid, userid, "unknown")</LI-CODE> Mon, 08 Aug 2022 12:15:41 GMT https://community.splunk.com/t5/Splunk-Search/Help-with-Field-Extraction-How-draft-the-if-condition-to-achieve/m-p/608681#M211652 richgalloway 2022-08-08T12:15:41Z