Splunk Enterprise

Push the row-data to upper rows of the same column if the upper-rows are empty.

abhishekpatel2
Explorer

Currently I am having some  blank cell or null data in some row. So how can I fill that cells or rows with the data  that is in below row of that columns:

Currently my output for the query is:

Screenshot (154).png

 

The Output that I want is:-

Screenshot (155).png

Can someone please help me with this..

Labels (1)
0 Karma

aasabatini
Builder

Hi 

 

you can use "Sort" comand to order your output.

 

In addiction you can use fillnull comand to fill your blank fields 

https://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Fillnull

 

 

abhishekpatel2
Explorer

It only fill that field with null in case of fill null and sort columns if I use sort. But  I want to push the  row data to upwards to remove the blank rows.

0 Karma

aasabatini
Builder

In your case you need to use at the end of your search:

| sort -a (field)

 

 

0 Karma
Take the 2021 Splunk Career Survey

Help us learn about how Splunk has
impacted your career by taking the 2021 Splunk Career Survey.

Earn $50 in Amazon cash!