I want to replace Null with tr_1234.....
Find workflow attached
You want to replace any null with tr_1234? or replace null based on the d_id?
If you just want to replace Null you can use a formula with
If [d_id]="Null" then "t_1234" else [d_id] endif
if your null is really null then you should use
if isnull([d_id]) then "t_1234" else [d_id] endif
Hello - i want to replace only for Samid when it is null then it should replace with nearest id like that for every d_id
below is my data
result should be like this:
