Replacing Null Fields

[anthony_wright]

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? 

[Ned · Accepted solution]

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? 

[davidhenington]

haha, apologies, i see that's exactly what this does. Excellent, love you Alteryx! 

[cdaragan]

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