Alteryx Designer Desktop Discussions

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

How to replace null value with previous row data

Saravanan13
8 - Asteroid

Hello all,

 

I am looking to duplicate the values in previous row whenever there is a null value. Can anyone assist. I know we can use multi row field  formula but not getting the desired  output.

 

Input

accountsParent
1225232323232
5454 
545444 
242323 
43333 
3343435454545454
3433 
343334 
5454554 
3433334545454545
322222 
423211 
24313126767676767
344343 
4544544 
433433 

 

 

 

Output-

 

accountsParent
1225232323232
5454232323232
545444232323232
242323232323232
43333232323232
3343435454545454
34335454545454
3433345454545454
54545545454545454
3433334545454545
3222224545454545
4232114545454545
24313126767676767
3443436767676767
45445446767676767
4334336767676767
2 REPLIES 2
MilindG
12 - Quasar

@Saravanan13  Does this work for you?

CoG
14 - Magnetar

In Multi Row Formula Tool, use the following formula:
IIF( IsNull( [Parent] ), [Row-1:Parent], [Parent] )

 

Screenshot.png

Hope this helps and Happy Solving!

Labels
Top Solution Authors