assign position number

[Alteryxnewbie27]

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:

group	volume
1	105
1	70
1	71
1	43
1	56
1	72
1	67
1	68
2	96
2	99
2	105
2	111
2	115
2	118
2	87
2	44
2	55
2	32
2	31
3	36
3	32
3	45
3	56

Output

group	volume	position
1	105	G1 1
1	70	G1 2
1	71	G1 3
1	43	G1 4
1	56	G1 5
1	72	G1 6
1	67	G1 7
1	68	G18
2	96	G2 1
2	99	G2 2
2	105	G2 3
2	111	G2 4
2	115	G2 5
2	118	G2 6
2	87	G2 7
2	44	G2 8
2	55	G2 9
2	32	G2 10
2	31	G2 11
3	36	G3 1
3	32	G3 2
3	45	G3 3
3	56	G3 4

Group	volume count > 100
1	1
2	4
3	0

[BrandonB · Accepted solution]

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

 

 

[Alteryxnewbie27]

Thank you, BrandonB!