Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

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

MultiRow Formula

gmia
5 - Atom

Hello,

I cannot get the right formula for the following:

 

 1. On column 20, when P1 is consecutive I need the records from 7th row to have them on 4th row and 6 on 5 (output in the workflow for a better view). 
 2. On column 20, when P1 is not consecutive, I need the records shifted with one above, record 14 to record 13. 

 

I got the formula working for the second situation, but I am not sure how to tackle the first one, as it goes weird in my workings attached.

Please note it happens in a larger file with many lines when these 2 specific scenarios can happen.


Thank you!

1 REPLY 1
Christina_H
14 - Magnetar

I've taken a different approach, assigning a record ID then calculating the correct record ID to match the extra rows to.  Hopefully it'll work with your larger data set.

Labels
Top Solution Authors