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.

Solution

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: