community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

How to fill rows in the reverse direction?

Alteryx Partner

Hello, 

 

Does anyone know how to fill rows in the reverse direction?

 

Capture.PNG

 

As in get the string value in Record #15 [Award] to fill up the empty rows all the way to #1 and the string value in Record #27 [Award] to fill up the empty rows all the way up to #16 and so on?

 

I have tried multi-row formula but only know how to use it going in a downwards direction. 

 

Thank you, 

 

Seffana

Alteryx Certified Partner
Alteryx Certified Partner

Hi @Seffana 

 

The secret is to sort your data in a reverse order (using RecordID), and then use Multi-Row Formula Tool to fill-in the empty spaces.

 

Workflow of this example appended.

 

Solution.PNG


Cheers,

Labels