Knowledge Management

How to get lookup header names as field's values

smart111
Explorer

smart111_0-1634832219579.png


Is there any way to get those header names as field values from lookup files?
Please give me any idea with SPL

 

Labels (1)
Tags (1)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

You could transpose, duplicate the header column and transpose again

| inputlookup lookup.csv
| transpose 0 header_field="NAME" column_name="NAME"
| eval header=NAME
| transpose 0 header_field=header column_name="NAME"

 

View solution in original post

ryanoconnor
Builder

Can you explain the use case a little bit more? This looks like it might be a screenshot from Microsoft Excel. 

Have you looked into the Lookup File Editor App?  https://splunkbase.splunk.com/app/1724/

0 Karma

smart111
Explorer

Thank you for answering @ryanoconnor 

I actually wanted to set a dropdown list of lookup header values on dashboard and make it possible to choose a primary key to  lookup reference field dynamically.

Thank you for your kindness.

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

You could transpose, duplicate the header column and transpose again

| inputlookup lookup.csv
| transpose 0 header_field="NAME" column_name="NAME"
| eval header=NAME
| transpose 0 header_field=header column_name="NAME"

 

smart111
Explorer

Thank you so much, @ITWhisperer 

This way is exactly I wanted.

0 Karma
Get Updates on the Splunk Community!

Data Management Digest – November 2025

  Welcome to the inaugural edition of Data Management Digest! As your trusted partner in data innovation, the ...

Splunk Mobile: Your Brand-New Home Screen

Meet Your New Mobile Hub  Hello Splunk Community!  Staying connected to your data—no matter where you are—is ...

Introducing Value Insights (Beta): Understand the Business Impact your organization ...

Real progress on your strategic priorities starts with knowing the business outcomes your teams are delivering ...