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

Vlookup for minimum or maximum date

johnnykoung
8 - Asteroid

Hi,

I have a set of data with an ID and a start date and end date. It looks like this:

ID     Start Date     End Date
1       7/1/2019       12/31/2019

1       8/1/2019        11/29/2019

2       2/1/2019          5/1/2019

2       3/1/2019          6/1/2019

If I just get a unique list of IDs (in this case the list would be 1,2), how could I join/vlookup the minimum start date for that ID and the maximum end date for that ID? The end result should come out to

ID     Start Date     End Date
1       7/1/2019       12/31/2019
2       2/1/2019        6/1/2019

Thanks,

Johnny

 

2 REPLIES 2
NickSm
Alteryx
Alteryx

@johnnykoung 


Summarize tool actually works really well for this. Just have to have the dates in the recognized date format of yyyy-MM-dd

 

clipboard_image_0.png

johnnykoung
8 - Asteroid

That's perfect, thank you! Didn't realize the summarize function had those options.

Labels