In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Replacing Null Fields

anthony_wright
6 - Meteoroid

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? 

4 REPLIES 4
Ned
Alteryx Alumni (Retired)

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
10 - Fireball

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

davidhenington
10 - Fireball

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

cdaragan
5 - Atom

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

Labels
Top Solution Authors