Lets say I have 3 lookups >>> a-list.csv, b-list.csv, c-list.csv and the lists only have 1 column header = Name Alice is on a-list Bob is on b-list Charles is on c-list There are lots of people on each list and the lists are dynamic and updated. I have a request to create a Combined_Master Lookup (where C_M-list.csv = a-list.csv + b-list.csv + c-list.csv), where the list contains NAME, FLAG fields such as NAME,FLAG Alice, a-list Bob, b-list Charles, c-list So far I use the following query to build the C_M-list.csv, where there is a Name and Flag appended to each name (which indicate which list the person is from) BUT I am wondering if there is a better way... | inputlookup a-list.csv
| eval FLAG = "a-list"
| inputlookup b-list.csv append=true
| eval FLAG = coalesce(FLAG, "b-list")
| inputlookup c-list.csv append=true
| eval FLAG = coalesce(FLAG, "c-list")
|.... <rest of the query follows>.... My desired outcome is a M_C-list.csv Alice,a-list Bob,b-list Charles,c-list Any suggestions or improvements appreciated. TY!
... View more