Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Multi-Row formula tool to fill up the way

Highlighted
7 - Meteor

Multi-Row formula tool to fill up the way, So i have attached the spreadsheet so I want the following to fill up the way rather then down. If I use te below formula I know it will fill down till it stops seeing Null. 

IF IsNull([Currency]) THEN [Row-1:Currency] ELSE [Currency] ENDIF

 

But when I use this statement below it only fill's up by one line. Any chance someone could show what I am doing wrong

IF IsNull([Currency]) THEN [Row+1:Currency] ELSE [Currency] ENDIF

Highlighted
17 - Castor
17 - Castor

Hi @JamesG2806 

 

The multi-row tool always goes from the top to the bottom.  If you need to go from the bottom to the top, add a RecordID and sort by this recordID descending.   This reverses the order of your records.  Use a Multi-row to fill in what you need and then sort by recordID ascending to get the original order back.

 

Dan 

Highlighted
7 - Meteor

Perfect thanks for that 

Labels