Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Multi-row Formula Question


Hi everyone,


I'm trying to create a mapping file based on if the TM Column has an A in it and make all the rows above that equal that output as well. So I did 


IF [TM]="A" THEN [Account] ELSE [Row-1:Mapping] ENDIF


As you can see based on the attachment it is skipping my first set of data which is making the entire output be shifted down which is wrong. I understand this is because I'm doing Row-1 and it is taking the first active row but when I try Row+1 it is saying it doesn't exist so I'm wondering if anyone knows a way around this?

Alteryx Certified Partner
Alteryx Certified Partner

Hi @kdelisi002 


How does your original data look like?


I think if you set this option to be true - "Set to Values of Closest Valid Row", it will work well.








I tried that and it still leaves the top blank. Attached is the original data

Alteryx Certified Partner
Alteryx Certified Partner



I get what you mean. Here's an alternative:



- Add a Record ID

- Sort your data by Record ID descending (reversing the order of your data)

- Use the Multi-Row formula as you did

- Sort the data back




Thanks for the help, appreciate it!

Alteryx Partner

Hi @kdelisi002 ,


This looks like it produces the mapping file you were looking for.


Multi Row Help.png