Find the earliest date from a list

[salemalnahdi14]

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

For example, I have this dataset:

Product ID	Quantity Purchased	Purchase Date
1	3	1/24/2022
1	2	5/22/2022
1	5	8/15/2022
2	4	2/14/2022
2	7	4/12/2022
3	2	8/23/2022

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

Product ID	Quantity Purchased	Purchase Date
1	3	1/24/2022
2	4	2/14/2022
3	2	8/23/2022

Thanks!

[flying008]

Hi, @salemalnahdi14 

[KrishnaChithrathil · Accepted solution]

@salemalnahdi14 

you can do it using Summarize tool.

group by Product ID and min of Date.

[DenisZ]

Please see attached workflow.

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]

@salemalnahdi14 One way of doing this

[bgorhamaan]

However this won't work if there are multiple rows with the same minimum [purchase] date for each [Product] ID (which was how my dataset is). I had to go with the Sort and Sample method.