Splunk Search

stats, empty columns and fillnull

astarchenkov
Explorer

alt text

I've problems not only with fillnull in this search which doesn't fill my columns with 12. If I add "| table *" after or instead of fillnull line I'll miss my columns at all. I want save my empty columns.

Is this bug or feature? Can be problem solved without "foreach" with "isnull"?

0 Karma

tiagofbmm
Influencer

Hey

It is not surprising your fillnull isn't doing anything. The reason is that you filtered only the rows with prediction and value that actually are not null (by having used the *). The rows that look like having a null value are actually not null. You can recheck that with eval isnull function just to be sure.

To replace those values that look null but aren't, maybe check the length of the value and replace it by 12. But I'm assuming things, this depends on your scenario specifically speaking

astarchenkov
Explorer

Hi

I've checked, they are null so if you will use if and isnull this is ok.. The main problem is that I miss columns if I return it from my custom command and the first line has no data in this columns. If the first line has all data this columns are ok and have empty field on several lines. When I started debugging I found upper surprise with fillnull.

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud’s AI Assistant in Action Series: Analyzing and ...

This is the second post in our Splunk Observability Cloud’s AI Assistant in Action series, in which we look at ...

Elevate Your Organization with Splunk’s Next Platform Evolution

 Thursday, July 10, 2025  |  11AM PDT / 2PM EDT Whether you're managing complex deployments or looking to ...

Splunk Answers Content Calendar, June Edition

Get ready for this week’s post dedicated to Splunk Dashboards! We're celebrating the power of community by ...