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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
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

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

Highlighted
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