topic How do I insert values for different fields in different rows? in Splunk Search https://community.splunk.com/t5/Splunk-Search/How-do-I-insert-values-for-different-fields-in-different-rows/m-p/435333#M124133 <P>HI,</P> <P>My data is like ,</P> <P>Sno Name URL Column2<BR /> 1 A Null Null<BR /> 2 Null https:/ Null<BR /> 3 Null Null fast</P> <P>Here I need to fill values in null values using our Splunk search query.</P> <P>Please help with this query. How do I insert values in the Null value fields?</P> <P>Regards.</P> Tue, 16 Oct 2018 08:09:12 GMT umsundar2015 2018-10-16T08:09:12Z How do I insert values for different fields in different rows? https://community.splunk.com/t5/Splunk-Search/How-do-I-insert-values-for-different-fields-in-different-rows/m-p/435333#M124133 <P>HI,</P> <P>My data is like ,</P> <P>Sno Name URL Column2<BR /> 1 A Null Null<BR /> 2 Null https:/ Null<BR /> 3 Null Null fast</P> <P>Here I need to fill values in null values using our Splunk search query.</P> <P>Please help with this query. How do I insert values in the Null value fields?</P> <P>Regards.</P> Tue, 16 Oct 2018 08:09:12 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-insert-values-for-different-fields-in-different-rows/m-p/435333#M124133 umsundar2015 2018-10-16T08:09:12Z Re: How do I insert values for different fields in different rows? https://community.splunk.com/t5/Splunk-Search/How-do-I-insert-values-for-different-fields-in-different-rows/m-p/435334#M124134 <P>You can use | fillnull value=</P> <P>If you want to give value for Specific fields.</P> <P>| fillnull value=</P> Tue, 16 Oct 2018 08:14:10 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-insert-values-for-different-fields-in-different-rows/m-p/435334#M124134 SathyaNarayanan 2018-10-16T08:14:10Z Re: How do I insert values for different fields in different rows? https://community.splunk.com/t5/Splunk-Search/How-do-I-insert-values-for-different-fields-in-different-rows/m-p/435335#M124135 <P>Thanks for your reply .<BR /> But i need to insert unique values for each field and row .<BR /> Can some on help me .</P> Tue, 16 Oct 2018 11:04:25 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-insert-values-for-different-fields-in-different-rows/m-p/435335#M124135 umsundar2015 2018-10-16T11:04:25Z Re: How do I insert values for different fields in different rows? https://community.splunk.com/t5/Splunk-Search/How-do-I-insert-values-for-different-fields-in-different-rows/m-p/435336#M124136 <P>You use eval command with if or Match for it.</P> <P>| eval test=if(fieldname=fieldvalue,unique value , 0)</P> Tue, 16 Oct 2018 11:14:16 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-insert-values-for-different-fields-in-different-rows/m-p/435336#M124136 SathyaNarayanan 2018-10-16T11:14:16Z Re: How do I insert values for different fields in different rows? https://community.splunk.com/t5/Splunk-Search/How-do-I-insert-values-for-different-fields-in-different-rows/m-p/435337#M124137 <P>Hi @umsundar2015 ,<BR /> you can use the below query to fill specific value.</P> <PRE><CODE>base search | eval field_name= if(field_name==" ", "-", field_name) </CODE></PRE> <P>This query will fill '-' if any null value come, else field value will be passed.</P> Tue, 16 Oct 2018 11:17:45 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-insert-values-for-different-fields-in-different-rows/m-p/435337#M124137 twh1 2018-10-16T11:17:45Z Re: How do I insert values for different fields in different rows? https://community.splunk.com/t5/Splunk-Search/How-do-I-insert-values-for-different-fields-in-different-rows/m-p/435338#M124138 <P>Please specify what you want the output to look like.</P> Tue, 16 Oct 2018 14:34:15 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-insert-values-for-different-fields-in-different-rows/m-p/435338#M124138 DalJeanis 2018-10-16T14:34:15Z