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! 

Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Quick connection discovery mode for forwarders

When a Splunk forwarder loses connectivity to its indexers, it does not always reconnect immediately. In many ...

Build and Launch AI Agents from Your Splunk Workflows

  Register We’ve all been there: juggling alerts, runbooks, and endless manual searches. What if you could ...

Splunk Cloud Application Management in Terraform

Register   On Tuesday, August 4 at 11AM PDT / 2PM EDT, we’re diving into how you can bring Infrastructure as ...