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.....
Solved! Go to Solution.
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
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 |
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