Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to find maximum aging value of a reference ID

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.

2 REPLIES 2
DataNath
17 - Castor

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.

 

DataNath_1-1655461921892.png

 

 

bensilv
Alteryx
Alteryx

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.

 

bensilv_0-1655461909436.png

 

 

All the best

Ben

Labels