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!

Data Management Digest – December 2025

Welcome to the December edition of Data Management Digest! As we continue our journey of data innovation, the ...

Index This | What is broken 80% of the time by February?

December 2025 Edition   Hayyy Splunk Education Enthusiasts and the Eternally Curious!    We’re back with this ...

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...