add field values for null field

[raiqbal47010]

I have t wo coloum alog with data

dataset A datasetB
User A 1.2.3.4
User B

User C x.x.x.x
User D x.x.x.x
User E x.y.z.a

How can I add the static values against userB

[renjith_nair · Accepted solution]

@raiqbal47010,

Use fillnull

"your search" |fillnull value="your static value" datasetB