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!

.conf25 Global Broadcast: Don’t Miss a Moment

Hello Splunkers, .conf25 is only a click away.  Not able to make it to .conf25 in person? No worries, you can ...

Observe and Secure All Apps with Splunk

 Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

What's New in Splunk Observability - August 2025

What's New We are excited to announce the latest enhancements to Splunk Observability Cloud as well as what is ...