HI,
My data is like ,
Sno Name URL Column2
1 A Null Null
2 Null https:/ Null
3 Null Null fast
Here I need to fill values in null values using our Splunk search query.
Please help with this query. How do I insert values in the Null value fields?
Regards.
Please specify what you want the output to look like.
Hi @umsundar2015 ,
you can use the below query to fill specific value.
base search | eval field_name= if(field_name==" ", "-", field_name)
This query will fill '-' if any null value come, else field value will be passed.
You can use | fillnull value=
If you want to give value for Specific fields.
| fillnull value=
Thanks for your reply .
But i need to insert unique values for each field and row .
Can some on help me .
You use eval command with if or Match for it.
| eval test=if(fieldname=fieldvalue,unique value , 0)