Splunk Search

How to use multisearch for inputlookup tables ? please provide an example.

Uday_Gonti
New Member

I want to check data from two different lookup tables and relate it using multisearch command.

0 Karma

RickWilson
Engager

I have a case where I have several lookup tables which I want to join on the same key. I use append to make the union of all the events, then use | stats values(*) as * by key to combine them back to a single event per key, with the union of all the lookup values. For my data volume, this works well.

| inputlookup file1.csv where condition
| append [ | inputlookup file2.csv where condition]
| append [ | inputlookup file3.csv where condition]

| stats values(*) as * by key
0 Karma

elliotproebstel
Champion

If you are consulting two lookup tables, it's unlikely that you need multisearch. You can string multiple lookup commands in a single query. Can you tell us more about what you're trying to do, and we can suggest a good approach?

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud’s AI Assistant in Action Series: Analyzing and ...

This is the second post in our Splunk Observability Cloud’s AI Assistant in Action series, in which we look at ...

Elevate Your Organization with Splunk’s Next Platform Evolution

 Thursday, July 10, 2025  |  11AM PDT / 2PM EDT Whether you're managing complex deployments or looking to ...

Splunk Answers Content Calendar, June Edition

Get ready for this week’s post dedicated to Splunk Dashboards! We're celebrating the power of community by ...