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!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...