Splunk Search
Highlighted

How to write a search to join the data from four lookups on a unique field?

New Member

Hello Experts,

Can you please help me with a search to join these four lookups on login (unique field). Lookups LOOKUPA.CSV, LOOKUPB.CSV, LOOKUPC.CSV need to be joined to MASTERlookup to form a RESULT_LOOKUP.

Appreciate your help with this.

Please check the source lookups and resultingdesired lookup. (attachment/inline image)

alt text

0 Karma
Highlighted

Re: How to write a search to join the data from four lookups on a unique field?

SplunkTrust
SplunkTrust

What about this?

| inputcsv MASTER_LOOKUP.csv
| join type=left login [| inputcsv LOOKUP_A.csv]
| join type=left login [| inputcsv LOOKUP_B.csv]
| join type=left login [| inputcsv LOOKUP_C.csv]
| outputcsv RESULT_LOOKUP.csv
0 Karma
Highlighted

Re: How to write a search to join the data from four lookups on a unique field?

Contributor

Another option?

| inputlookup  MASTER_LOOKUP.CSV | inputlookup LOOKUP_A.CSV append=t | inputlookup LOOKUP_B.CSV  append=t | inputlookup LOOKUP_C.CSV  append=t | outputlookup RESULT_LOOKUP.csv
0 Karma