Splunk Search

item and time column lookup help

BP9906
Builder

I have several rows of a CSV lookup
Name,00:00,00:15,00:30
test1,A,A,A
test2,A,N,N

I want to matchup _time with the column name and give me that value for each of the rows.

_time=00:15 (ie bin span=15m _time)

results should be:

Name,result
test1,A
test2,N

How do I accomplish this since the columns have the values? I tried foreach and map, but have come up empty handed.

Thanks.

Tags (1)
0 Karma

jkat54
SplunkTrust
SplunkTrust

You can open the csv copy everything and “paste special” then use the paste option that rotates the data 90 deg. Do that before indexing data...

Or you can use the transpose command to do the same at search time. Will have to dress it up a bit but it would look something like this after transpose

Col1, col2,
TestName, Time

Try this:

| transpose
| rename col2 as _time, col1 as Name

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...