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:
The Output that I want is:-
Can someone please help me with this..
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
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.
In your case you need to use at the end of your search:
| sort -a (field)