Grouping of data based on min value of a column

[PawanTeza]

Hello,

My name is Pawan. I am new to Alteryx. I working on my data set and got stuck. This may be a simple one but I am not able to figure out. I have data something like this

Item	Date	Batch
1	11.09.2019	qwerty12
1	12.09.2019	uioplk23
2	11.09.2019	ghjuyu
3	13.09.2019	dhhfyu
3	15.09.2019	cnmdke
4	14.09.2019	shshkjke
4	16.09.2019	dvnjdl

Now, if I want the "Item" with the minimum "Date" along with respective "Batch", how can I do it. So ideally I should have one Item, Date, Batch Combined. Please help me.

Thank you all in advance.

[JosephSerpis]

Hi @PawanTeza the attached workflow produces the output you describe. Let me know what you think?

[PawanTeza]

Thank you for quick reply. But what I am trying to achieve is something like this.

Item	Date	Batch
1	11.09.2019	qwerty12
2	11.09.2019	ghjuyu
3	13.09.2019	dhhfyu
4	14.09.2019	shshkjke

In case of Items 1,3,4 there are double dates with double batches. I would like to get only the batch with minimum or nearest date. In case of Item 2, as there is only one entry I want it as it is. 

Please let me know if this possible.

Thank you!

[benakesh]

Hi @PawanTeza ,

Summarize and join gives minimum date rows. 

[JosephSerpis · Accepted solution]

Hi @PawanTeza you can do that in two ways have attached a workflow which showcases this.

[PawanTeza]

Thank you. That helps