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
Get Updates on the Splunk Community!

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Enhance Security Operations with Automated Threat Analysis in the Splunk EcosystemAre you leveraging ...

Splunk Developers: Go Beyond the Dashboard with These .Conf25 Sessions

  Whether you’re building custom apps, diving into SPL2, or integrating AI and machine learning into your ...

Index This | How do you write 23 only using the number 2?

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