Splunk Search

stats, empty columns and fillnull

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

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

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