Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Copy value from previous row

aishwarya_baburaj98
6 - Meteoroid

If below is the input I have: 

FruitsValue
Apple12
Orange45
Banana 
Grapes10

As you can see there is no value allocated for Banana. In this scenario, I want to copy the value above for Orange (45) to the Value column for Banana.

This way I will be having value for Banana as 45. How do I achieve this? 

2 REPLIES 2
binuacs
20 - Arcturus
Spoiler
binuacs_0-1637877492027.png

 

aishwarya_baburaj98
6 - Meteoroid

@binuacs This is perfect. Thanks!

Labels