Skip to main content
Lantern Home

 

Splunk Lantern

Replacing null values by using the fillnull and filldown commands

  1. Last updated
  2. Save as PDF

Null values are field values that are missing in a particular result but are present in another result. You're finding that some of your searches result in a lot of null values, which can make your reports look confusing or messy. You'd like to replace them with something different.

How to use Splunk software for this use case 

You can use fillnull and filldown to replace null values in your results. The fillnull command replaces null values in all fields with a zero by default. The filldown command replaces null values with the last non-null value for a field or set of fields.

This video shows you both commands in action.

Next steps

This article has been brought to you by Splunk Education. We’ve learned that the strongest superheroes up-skill with Splunk Education. That’s why we are making Splunk training easier and more accessible than ever with more than 20 self-paced, free eLearning courses. You can start with foundational courses like Intro to Splunk or dive into more advanced courses like Search Under the Hood, Result Modification, and many more. Enroll today so you have the skills to detect the good, the bad, and the unproductive.

In addition, these resources might help you understand and implement this guidance:

  • Splunk Help: Fillnull
  • Splunk Help: Filldown

  • Splunk OnDemand Services: Use these credit-based services for direct access to Splunk technical consultants with a variety of technical services from a pre-defined catalog. Most customers have OnDemand Services per their license support plan. Engage the ODS team at ondemand@splunk.com if you would like assistance.