Getting Data In

mapping headers to data in csv

thirumalreddyb
Communicator

I want to map headers to the data in the csv to search the fields as key=value pair, the sample log is shared below. please help

,,,Date,Time,Sensor Id a,Reading a,Sensor Id b,Reading b,Sensor Id c,Reading c,Sensor Id d,Reading d
,,,01-Jan-12,0:00:00,T001,170.3,T002,168.7,T003,169.7,T004,171.2
,,,01-Jan-12,00:30:00,T001,170.1,T002,168.5,T003,169.5,T004,171
,,,01-Jan-12,1:00:00,T001,170,T002,168.4,T003,169.4,T004,170.8
,,,01-Jan-12,1:30:00,T001,169.6,T002,168.2,T003,169.3,T004,170.5

Tags (1)
0 Karma
1 Solution

the_wolverine
Champion

You can do this by configuring header-based field extractions:
http://docs.splunk.com/Documentation/Splunk/5.0.2/Data/Extractfieldsfromfileheadersatindextime

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!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...