Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Finding a MIN and MAX across multiple rows

JohnMaty
9 - Comet

I have the attached scenario in a data table.  These represent placement of kids by case # (Matter_ID)

I need to collapse the rows down by Placement and the time span.  For example, I have one kid that has been in 3 types of placement over different periods of time. I need to collapse the Placement - Supervised Independent Living down from 3 to 1 span that is 2011-10-01 to 2018-02-22 (the current date).

 

I don't know how to do that and this can happen to any placement type.  It needs to be by case (Matter_ID).  Any  help would be appreciated

1 REPLY 1
patrick_digan
17 - Castor
17 - Castor

@JohnMaty Hopefully the attached will point you in the right direction. I think a multi-row tool to update the from date could do it. I chose this method in case there were any gaps.

Capture.PNG

Labels
Top Solution Authors