How to find maximum aging value of a reference ID

Question

Hi I am trying to create a new column that looks into 2 columns: the Reference ID column and the Aging column.

For example:

Age    Max Aging   Trade Reference
1         5                 ABCD
2         5                 ABCD
3         5                 ABCD
4         5                 ABCD
5         5                 ABCD
1         4                 EFGH
2         4                 EFGH
3         4                 EFGH
4         4                 EFGH
1         3                 IJKL
2         3                 IJKL
3         3                 IJKL

The "Max Aging" for Trade Ref ABCD is 5 based on the Aging column and so on and so forth.

How can I approach this in Alteryx in order to reflect the new max aging column? Thanks.

bensilv · Answer

Hi @karizze_fitzgeraldine,

You could either use a multi-row formula, or a summarise with a join. For the latter, I have created a workflow for you to show you how it could be done.

All the best

Ben

Max Age.yxmd

DataNath · Answer

Hey @karizze_fitzgeraldine, you can do that using the summarize tool - you just group by the reference and select 'max' to find the highest within that group. After that, you can just join it back using the reference as the key! Workbook attached.

Max aging ref.yxmd