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!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

Splunk is officially part of Cisco

Revolutionizing how our customers build resilience across their entire digital footprint.   Splunk ...

Splunk APM & RUM | Planned Maintenance March 26 - March 28, 2024

There will be planned maintenance for Splunk APM and RUM between March 26, 2024 and March 28, 2024 as ...