https://community.splunk.com/t5/Splunk-Search/InputLookup-find-unique-values-across-4-fields/m-p/329266#M98014 <P>Try this</P> <PRE><CODE>| inputlookup yourlookup.csv | table field1 field2 field2 field4 | eval temp=1 | untable temp field AccountNumber | stats dc(AccountNumber) as UniqueAccountNumbers </CODE></PRE> Thu, 12 Apr 2018 15:43:54 GMT somesoni2 2018-04-12T15:43:54Z https://community.splunk.com/t5/Splunk-Search/InputLookup-find-unique-values-across-4-fields/m-p/329265#M98013 <P>I have a lookup file that contain 4 fields (field1, field2, field3, field4) which contains an account number. Same account number can exist across the different fields as well as unique account numbers in these fields. I need a search that provides a count of unique account numbers across the 4 fields (and as a separate list of events). </P> Thu, 12 Apr 2018 15:31:50 GMT https://community.splunk.com/t5/Splunk-Search/InputLookup-find-unique-values-across-4-fields/m-p/329265#M98013 brdr 2018-04-12T15:31:50Z https://community.splunk.com/t5/Splunk-Search/InputLookup-find-unique-values-across-4-fields/m-p/329266#M98014 <P>Try this</P> <PRE><CODE>| inputlookup yourlookup.csv | table field1 field2 field2 field4 | eval temp=1 | untable temp field AccountNumber | stats dc(AccountNumber) as UniqueAccountNumbers </CODE></PRE> Thu, 12 Apr 2018 15:43:54 GMT https://community.splunk.com/t5/Splunk-Search/InputLookup-find-unique-values-across-4-fields/m-p/329266#M98014 somesoni2 2018-04-12T15:43:54Z https://community.splunk.com/t5/Splunk-Search/InputLookup-find-unique-values-across-4-fields/m-p/329267#M98015 <P>Nice. Will try it out. Thanks.</P> Thu, 12 Apr 2018 16:25:25 GMT https://community.splunk.com/t5/Splunk-Search/InputLookup-find-unique-values-across-4-fields/m-p/329267#M98015 brdr 2018-04-12T16:25:25Z