Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

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

Rearrange records until specific condition

HectorPaniagua
5 - Atom

Hi everyone! I need to asign in a new column, specific records in a column to all rows above that specific record. To be clearer I attached an Excel file with the example. 

Thanks for the help! 😁

 

3 REPLIES 3
Felipe_Ribeir0
15 - Aurora

Hi @HectorPaniagua 

 

One way of doing this (UPDATED ***)

 

Felipe_Ribeir0_1-1674677520206.png

 

 

 

binuacs
17 - Castor

@HectorPaniagua One way of doing this

binuacs_0-1674683353921.png

 

HectorPaniagua
5 - Atom

Thanks a lot for your help, both answers were very useful! :D 

Labels