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

Create a rank by group

Sammy22
8 - Asteroid

hello,

 

i have the first 3 columns as below where i have a number for each product but i need to create the number based on which group it is in like in the 'new number' column.

 

ProductgroupnumberNew number
23243a11
23244a22
23245a33
23246a44
23247b51
23248b62
4 REPLIES 4
L_T
8 - Asteroid

@Sammy22 you could use a multi-row formula, grouping by "group"

 

L_T_0-1667821507357.png

 

Felipe_Ribeir0
16 - Nebula

Hi @Sammy22 

 

You can use the tile tool to do it automatically for you

 

Felipe_Ribeir0_0-1667821937052.png

 

binuacs
20 - Arcturus

@Sammy22 similar to @L_T solution

 

binuacs_0-1667822481767.png

 

jpmoralesgar
6 - Meteoroid

Thank you, it was very helpful :) 

Labels