Replacing Nulls with existing value

[kirangottu]

d_id	Sam_id	tname
1	Null	miles
1	Null	phases
1	tr_1234	tasks
1	tr_1234	tasks
1	tr_1234	tasks
1	tr_1234	tasks
1	tr_1234	tasks
1	tr_1234	tasks
1	tr_1234	tasks

I want to replace Null with tr_1234.....

[mborriero]

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

[kirangottu]

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

d_id	Sam_id	tname
1	Null	miles
1	Null	phases
1	tr_1234	tasks
1	tr_1234	tasks
1	tr_1234	tasks
1	tr_1234	tasks
1	tr_1234	tasks
1	tr_1234	tasks
1	tr_1234	tasks
2	Null	miles
2	Null	phases
2	tr_1235	tasks
2	tr_1235	tasks
2	tr_1235	tasks
2	tr_1235	tasks
2	tr_1235	tasks
2	tr_1235	tasks
2	tr_1235	tasks

result should be like this:

d_id	Sam_id	tname
1	tr_1234	miles
1	tr_1234	phases
1	tr_1234	tasks
1	tr_1234	tasks
1	tr_1234	tasks
1	tr_1234	tasks
1	tr_1234	tasks
1	tr_1234	tasks
1	tr_1234	tasks
2	tr_1235	miles
2	tr_1235	phases
2	tr_1235	tasks
2	tr_1235	tasks
2	tr_1235	tasks
2	tr_1235	tasks
2	tr_1235	tasks
2	tr_1235	tasks
2	tr_1235	tasks

[tom_montpool]

Summarize on d_id and sam_id

Remove sam_id="Null" or IsNull(sam_id)

Join sam_id back into your main file using d_id as the join field

[mborriero · Accepted solution]

Find workflow attached