We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Group by numbers and get a condition Max date

Lumjing
8 - Asteroid

I want to get the below "Max date" say if I group by number 92 the the max date would be 3/3/2022. However if there is blank then max date will be blank as for the number 86. Can you please help to achieve this

 

numbers     Output dates          Max date
86               1/30/2022
86               1/30/2022
86
86               1/30/2022
92                2/3/2022               3/3/2022
92                1/3/2022
92                3/3/2022
92               4/2/2022

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @Lumjing 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1644427382554.png

 

Hope this helps : )

 

gabrielvilella
14 - Magnetar

Please mention exactly what is your input data and the desired output. 

Akash__on
8 - Asteroid

the dates are given in 

 

mm/dd/yyyy

 

format so how could 3/3/2022 (march 3 2022) be max date when we have 4/2/2022 (april 2 2022) present ?

I think it's a typo.

 

 

Lumjing
8 - Asteroid

thank you for the help I was able to get the desired output

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Lumjing 

Cheers and have a nice day!

Labels
Top Solution Authors