Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Multi-row Formula Question

kdelisi002
7 - 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?

5 REPLIES 5
Thableaus
17 - Castor
17 - Castor

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,

kdelisi002
7 - Meteor

Hi, 

 

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

Thableaus
17 - Castor
17 - Castor

@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,

kdelisi002
7 - Meteor

Thanks for the help, appreciate it!

john_miller9
11 - Bolide

Hi @kdelisi002 ,

 

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

 

Multi Row Help.png

Labels