Hi  I wish to dedup and consolidate customer details across two cities. E.g.  I have 2 records of the same customer across two cities and I want to consolidate them into 1 row NewCustomerID City1_CustomerID City2_CustomerID City isActiveCustomer 12345 00001   A Y 12345   00002 B N   Result:  * Merge City1_CustomerID and City2_CustomerID into one row * City Field populates the City where the customer is active * Field for ExistsInOtherCities is "Y" when there are 2 or more records.   NewCustomerID City1_CustomerID City2_CustomerID City isActiveCustomer ExistsInOtherCities 12345 00001 00002 A Y Y   I am used to SQL where I can make temp tables in each in then join it back but unsure how to do it in SPLUNK ... View more