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

Alteryx designer Discussions

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

Multi-row Formula Question

Meteor

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.

 

exqlqie1.PNG

 

Cheers,

Meteor

Hi, 

 

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

Alteryx Certified Partner
Alteryx Certified Partner

@kdelisi002 

 

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

Recoridasc.PNG

 

- 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

 

Cheers,

Meteor

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

Labels