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,
No, the order of the fields does not matter.
It's just important that the columns are consistent with the header.
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 :
no results for status_description
But got results when defining detailed results like
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.