Splunk Search

Outputlookup to override values of a single column in lookup.csv

mounicachinni
New Member

I have a search which returns a table with columns name,value,state - I have a lookup file (lookup.csv) with columns name,ID,num,state. I want to read state from my table and override(Not append) that value(Only state) in the lookup file which has the matching name as the table. Could some one help me with it.

my search | append [inputlookup lookup.csv | lookup lookup.csv name OUTPUT status | outputlookup append=false lookup.csv ]

But this is just appending the columns i want to override

Tags (1)
0 Karma
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...