Splunk Search

How to use fillnull for certain fields (and not for other ones)

rrovers
Contributor

My search ends with:

 

| table Afdeling 20* Voorlaatste* Laatste* verschil

 

It has several detail rows and 1 row with totals. I want to use fillnull for the totals for the 20* columns (2023-10, 2023-11 etc.) but not for Voorlaatste* Laatste* and verschil. 

I can't use 

 

| fillnull 20* value="0.0"

 

because that adds a column "20*" and I don't want to use fillnull 2023-10 etc.

Is there a way to do this?

Labels (2)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

The fillnull command does not support wildcards.  Try using foreach as a wrapper around fillnull.

| foreach 20* [fillnull '<<FIELD>>' value="0.0"]

 

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

View solution in original post

richgalloway
SplunkTrust
SplunkTrust

The fillnull command does not support wildcards.  Try using foreach as a wrapper around fillnull.

| foreach 20* [fillnull '<<FIELD>>' value="0.0"]

 

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

Splunk Observability as Code: From Zero to Dashboard

For the details on what Self-Service Observability and Observability as Code is, we have some awesome content ...

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Shape the Future of Splunk: Join the Product Research Lab!

Join the Splunk Product Research Lab and connect with us in the Slack channel #product-research-lab to get ...