Splunk Search

eval by rows

jiaqya
Builder

i have a table data where in a row has 0's . i need to replace those 0 only for that row

ex:

rowname:data
one:5
two:0
three:0
four:5

in this example i want to change 0 belonging to rowname="two" to a different value, only that row.
how to achieve it..

Tags (2)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

You should be able to do it like this

... | eval data = if(rowname=="two" AND data==0, replacementValue, data)
| ...
---
If this reply helps you, Karma would be appreciated.

View solution in original post

0 Karma

richgalloway
SplunkTrust
SplunkTrust

You should be able to do it like this

... | eval data = if(rowname=="two" AND data==0, replacementValue, data)
| ...
---
If this reply helps you, Karma would be appreciated.
0 Karma

jiaqya
Builder

Thanks, just one more thing, what if i have more than 1 columns , like data, data 1, date2... etc

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Include the additional fields in the if function.

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Developer Spotlight with William Searle

The Splunk Guy: A Developer’s Path from Web to Cloud William is a Splunk Professional Services Consultant with ...

Major Splunk Upgrade – Prepare your Environment for Splunk 10 Now!

Attention App Developers: Test Your Apps with the Splunk 10.0 Beta and Ensure Compatibility Before the ...

Stay Connected: Your Guide to June Tech Talks, Office Hours, and Webinars!

What are Community Office Hours?Community Office Hours is an interactive 60-minute Zoom series where ...