Splunk Search

lookup with _row

oda
Communicator

Can I use _row when matching with lookup?
It seems to me that it can not be done.
Can you give me some hints?

0 Karma
1 Solution

HiroshiSatoh
Champion

If you search keywords

ex)
index=XXX [|inputlookup XXX.csv|table key_value|rename key_value as query]

Look at this
https://answers.splunk.com/answers/7472/subsearch-fields-query-search-how-do-i-know-which-to-use.htm...

View solution in original post

0 Karma

HiroshiSatoh
Champion

If you search keywords

ex)
index=XXX [|inputlookup XXX.csv|table key_value|rename key_value as query]

Look at this
https://answers.splunk.com/answers/7472/subsearch-fields-query-search-how-do-i-know-which-to-use.htm...

0 Karma

harsmarvania57
Ultra Champion

Why you want to match _raw data with lookup ? Can't you use any field value to match data with lookup ? If your fields values are not exactly matching with lookup table data then you can implement wildcard lookup.

0 Karma
Get Updates on the Splunk Community!

Index This | What is broken 80% of the time by February?

December 2025 Edition   Hayyy Splunk Education Enthusiasts and the Eternally Curious!    We’re back with this ...

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...

Splunk MCP & Agentic AI: Machine Data Without Limits

Discover how the Splunk Model Context Protocol (MCP) Server can revolutionize the way your organization uses ...