Splunk Search

Does the header sequence in a csv file for lookuptable matter?

Starlette
Contributor

Is there a rule for sequence of the header field in csv lookuptables?

Lets say i have a csv header

status,status_description,status_type
100,Continue,Informational
101,Switching Protocols,Informational
200,OK,Successful

In this example the status is a splunk event field, but are you restricted to this sequence?
lets say as below :

status_type,status,status_description
Informational,100,Continue
Informational,101,Switching Protocols
Successful,200,OK,
Tags (2)
0 Karma

mslvrstn
Communicator

No, the order of the fields does not matter.
It's just important that the columns are consistent with the header.

mslvrstn
Communicator

Do the events that match "searchstring" correspond to the sourcetype you have configured for the autolookup, and do those events already have one of the fields listed in the header? That's what it needs to fill out the rest of the field/values.

0 Karma

Starlette
Contributor

When configurating this in props.conf, transforms.conf (autolookup, on all fields)
Must you expect a return on all relevant events / lookup fields ( for this example) as :

"searchstring"

no results for status_description

But got results when defining detailed results like

sourcetype=blabla status=100

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Introduction to Splunk AI

How are you using AI in Splunk? Whether you see AI as a threat or opportunity, AI is here to stay. Lucky for ...

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...

Maximizing the Value of Splunk ES 8.x

Splunk Enterprise Security (ES) continues to be a leader in the Gartner Magic Quadrant, reflecting its pivotal ...