How do I insert values for different fields in different rows?

[umsundar2015]

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.

[DalJeanis]

Please specify what you want the output to look like.

[twh1]

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.

[SathyaNarayanan]

You can use | fillnull value=

If you want to give value for Specific fields.

| fillnull value=

[umsundar2015]

Thanks for your reply .
But i need to insert unique values for each field and row .
Can some on help me .

[SathyaNarayanan]

You use eval command with if or Match for it.

| eval test=if(fieldname=fieldvalue,unique value , 0)