InputLookup - find unique values across 4 fields

[brdr]

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).

[somesoni2]

Try this

| inputlookup yourlookup.csv | table field1 field2 field2 field4 | eval temp=1
| untable temp field AccountNumber
| stats dc(AccountNumber) as UniqueAccountNumbers

[brdr]

Nice. Will try it out. Thanks.