Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Find the earliest date from a list

salemalnahdi14
6 - Meteoroid

Hi, would love some help in automating finding the earliest date of purchase from the dataset below:

 

For example, I have this dataset:

 

Product IDQuantity PurchasedPurchase Date
131/24/2022
125/22/2022
158/15/2022
242/14/2022
274/12/2022
328/23/2022

 

I would love my output to look like this, extracting the earliest purchase date for each product:

 

Product IDQuantity PurchasedPurchase Date
131/24/2022
242/14/2022
328/23/2022

 

Thanks!

4 REPLIES 4
flying008
15 - Aurora

Hi, @salemalnahdi14 

 

flying008_0-1669607490997.png

 

KrishnaChithrathil
11 - Bolide

@salemalnahdi14 

you can do it using Summarize tool.

group by Product ID and min of Date.

 

KrishnaChithrathil_0-1669613472517.png

 

 

 

DenisZ
11 - Bolide

Please see attached workflow.

 

DenisZ_0-1669615687779.png

 

 

You would need to convert it to date, sort it correctly and then use the sample tool in which it is possible to group and it would pick the first of each group. Hope it helps.

 

Please mark as solved if it solves the issue. 

 

 

binuacs
21 - Polaris

@salemalnahdi14 One way of doing this

 

binuacs_0-1669622609033.png

 

Labels
Top Solution Authors