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

assign position number

Alteryxnewbie27
6 - Meteoroid

Hello All,

 

I am trying to add position of the record based on the group column criteria and summarize. Could somebody please help me with this.

 

Input:

 
groupvolume
1105
170
171
143
156
172
167
168
296
299
2105
2111
2115
2118
287
244
255
232
231
336
332
345
356

 

Output

groupvolumeposition
1105G1 1
170G1 2
171G1 3
143G1 4
156G1 5
172G1 6
167G1 7
168G18
296G2 1
299G2 2
2105G2 3
2111G2 4
2115G2 5
2118G2 6
287G2 7
244G2 8
255G2 9
232G2 10
231G2 11
336G3 1
332G3 2
345G3 3
356

G3 4

 

 

 

Groupvolume count > 100
11
24
30

 

 

2 REPLIES 2
BrandonB
Alteryx
Alteryx

Workflow attached. First desired output is after the top Select tool. Second desired output is after the Union tool. 

 

1.png

 

 

2.png

 

Alteryxnewbie27
6 - Meteoroid

Thank you, BrandonB!

Labels
Top Solution Authors