Splunk Search

how to write a request

gitingua
Communicator

| inputlookup file1.csv

field1field2
1a
2b
3c

 

it is necessary so

123
abc

 

 

help! Thanks 

 

Labels (5)
0 Karma
1 Solution

venkatasri
SplunkTrust
SplunkTrust

Hi @gitingua 

| inputlookup <lookup_name> | transpose | fields - column

you can rename 'row 1', row2 etc to desired ones

--

An upvote would be appreciated if this reply helps! 

View solution in original post

richgalloway
SplunkTrust
SplunkTrust

Have you looked at the transform command?

---
If this reply helps you, Karma would be appreciated.

venkatasri
SplunkTrust
SplunkTrust

Hi @gitingua 

| inputlookup <lookup_name> | transpose | fields - column

you can rename 'row 1', row2 etc to desired ones

--

An upvote would be appreciated if this reply helps! 

Get Updates on the Splunk Community!

App Platform's 2025 Year in Review: A Year of Innovation, Growth, and Community

As we step into 2026, it’s the perfect moment to reflect on what an extraordinary year 2025 was for the Splunk ...

Operationalizing Entity Risk Score with Enterprise Security 8.3+

Overview Enterprise Security 8.3 introduces a powerful new feature called “Entity Risk Scoring” (ERS) for ...

Unlock Database Monitoring with Splunk Observability Cloud

  In today’s fast-paced digital landscape, even minor database slowdowns can disrupt user experiences and ...