Splunk Search

How to use field name as the value passed into a lookup table?

TobiasBoone
Communicator
| foreach p* [eval val='<>' | lookup wkst_risk_control asset_risk_position AS 'val']

I have 19 separate p extraction fields called p0-p18. I am looking to loop through each of the field names called p* and do a lookup of the name of the field itself from the lookup table wkst_risk_control to get the supplemental data. I am struggling and missing something. Is foreach the best way or is there a more elegant method?

0 Karma

somesoni2
Revered Legend

Something like this should work

...| foreach p* [ lookup wkst_risk_control asset_risk_position AS "<<FIELD>>"]
0 Karma
Get Updates on the Splunk Community!

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI! Discover how Splunk’s agentic AI ...

[Puzzles] Solve, Learn, Repeat: Dereferencing XML to Fixed-length events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Stay Connected: Your Guide to December Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...