Populate max row num in one column to another column

[vujennyfer]

Hi all, 

Sorry I am new to Alteryx if this is a basic question. 

I am trying to select the max row num in one column and populate a new column with just the max value grouped by name. 

name	row_num	max
abc	1	4
abc	2	4
abc	3	4
abc	4	4
ccc	1	3
ccc	2	3
ccc	3	3
lll	1	2
lll	2	2

[Emil_Kos · Accepted solution]

Hi @vujennyfer,

I have created a workflow for you:

The output:

Please mark my post as a solution if this was helpful!

[Qiu]

@vujennyfer 

Just a diffrent thought😀

[vujennyfer]

Thank you! This is very helpful and worked 🙂