Replacing Null Fields

Need to replace Null values with value in first row.
(i.e. DIV field would test the row for If "IGS," then DIV 2 = "IGS" until it came across another value where DIV field if "ECS," then DIV 23 = "ECS."

What's the best way to approach this data preparation exercise?

Preparation

Accepted answers

Ned

This is exactly what the MultiRowFormula tool is for. The formula you need is:

if IsNull([DIV]) then [Row-1:DIV] else [DIV] endif

All comments

Ned

This is exactly what the MultiRowFormula tool is for. The formula you need is:

if IsNull([DIV]) then [Row-1:DIV] else [DIV] endif

davidhenington

what about using the last non-null value instead of the first?

cdaragan

Could you pls help me replacing null values with 'Unknown' in a table

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703