community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Grouping of data based on min value of a column

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

 

ItemDateBatch
111.09.2019qwerty12
112.09.2019uioplk23
211.09.2019ghjuyu
313.09.2019dhhfyu
315.09.2019cnmdke
414.09.2019shshkjke
416.09.2019dvnjdl

 

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.

Alteryx Certified Partner

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

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

 

ItemDateBatch
111.09.2019qwerty12
211.09.2019ghjuyu
313.09.2019dhhfyu
414.09.2019shshkjke

 

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!

Bolide

Hi @PawanTeza ,

Summarize and join gives minimum date rows. 

 

 

Highlighted
Alteryx Certified Partner

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

Thank you. That helps

Labels