Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Grouping of data based on min value of a column

PawanTeza
5 - Atom

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.

5 REPLIES 5
JosephSerpis
17 - Castor
17 - Castor

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

PawanTeza
5 - Atom

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!

benakesh
12 - Quasar

Hi @PawanTeza ,

Summarize and join gives minimum date rows. 

 

 

JosephSerpis
17 - Castor
17 - Castor

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

PawanTeza
5 - Atom

Thank you. That helps

Labels