https://community.splunk.com/t5/Splunk-Search/add-field-values-for-null-field/m-p/490283#M194137 <P>@raiqbal47010,</P> <P>Use <A href="https://docs.splunk.com/Documentation/SplunkCloud/latest/SearchReference/Fillnull">fillnull</A></P> <PRE><CODE>"your search" |fillnull value="your static value" datasetB </CODE></PRE> Tue, 26 Nov 2019 13:10:37 GMT renjith_nair 2019-11-26T13:10:37Z https://community.splunk.com/t5/Splunk-Search/add-field-values-for-null-field/m-p/490282#M194136 <P>I have t wo coloum alog with data</P> <P>dataset A datasetB<BR /> User A 1.2.3.4<BR /> User B<BR /><BR /> User C x.x.x.x<BR /> User D x.x.x.x<BR /> User E x.y.z.a</P> <P>How can I add the static values against userB</P> Tue, 26 Nov 2019 11:44:02 GMT https://community.splunk.com/t5/Splunk-Search/add-field-values-for-null-field/m-p/490282#M194136 raiqbal47010 2019-11-26T11:44:02Z https://community.splunk.com/t5/Splunk-Search/add-field-values-for-null-field/m-p/490283#M194137 <P>@raiqbal47010,</P> <P>Use <A href="https://docs.splunk.com/Documentation/SplunkCloud/latest/SearchReference/Fillnull">fillnull</A></P> <PRE><CODE>"your search" |fillnull value="your static value" datasetB </CODE></PRE> Tue, 26 Nov 2019 13:10:37 GMT https://community.splunk.com/t5/Splunk-Search/add-field-values-for-null-field/m-p/490283#M194137 renjith_nair 2019-11-26T13:10:37Z