In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Rownum with grouping

Anastasio_Theohari
8 - Asteroid

Hello,

 

I have this input 

 

NAME                                                                   ID                          

 

EDWARDS LIFESCIENCES DRO                      134-2

EDWARDS LIFESCIENCES DRO                      134-1

EDWARDS LIFESCIENCES DRO                      134-9

EL DORADO COATINGS INC.                            821-4

EL DORADO COATINGS INC.                            814-2

SHELL                                                                           432-1

 

I would like to create a rownum column group by the name,so the output it would be like the below : 

 

NAME                                                                   ID                  RecordID               

 

EDWARDS LIFESCIENCES DRO                      134-2                  1

EDWARDS LIFESCIENCES DRO                      134-1                  1

EDWARDS LIFESCIENCES DRO                      134-9                  1

EL DORADO COATINGS INC.                            821-4                  2

EL DORADO COATINGS INC.                            814-2                  2

SHELL                                                                          432-1                 3

 

Any idea how can i implemet this?

 

Thank you

 

2 REPLIES 2
DawnDuong
13 - Pulsar
13 - Pulsar

Hi @Anastasio_Theohari 

One way is to use the tile tool with “unique” tile method

 

https://help.alteryx.com/current/designer/tile-tool

 

dawn

 

KarolinaRoza
11 - Bolide

Hi @Anastasio_Theohari 

 

Another method is Multi-Row Formula with formula:

 

IF [Row-1:NAME]=[NAME] THEN [Row-1:RecordID] ELSE [Row-1:RecordID]+1 ENDIF

 

Workflow attached,

Karolina

Labels
Top Solution Authors