Combining rows with matching conditions

[OIT]

Can someone please support me on this topic? I am  Looking to combine rows that have different dates but have the same Task and Team.  In the result table, I'd like the min. of the two start dates and max. of end dates, and the total number of days(in a new column).  Thank you!

Engagement	Task	Team	start date	End date
XYZ	COM	A	20.01.2024	18.02.2024
ABC	ARG	C	21.02.2024	18.03.2024
IJK	NP	B	20.07.2024	18.08.2024
ABC	ARG	C	29.03.2024	18.04.2024
ABC	ARV	C	15.06.2024	10.07.2024

Output

Engagement	Task	Team	start date	End date	Number of weeks
XYZ	COM	A	20.01.2024	18.02.2024	4
ABC	ARG	C	21.02.2024	18.04.2024	8
IJK	NP	B	20.07.2024	18.08.2024	4
ABC	ARV	C	15.06.2024	10.07.2024	3

[DataNath]

Hey @OIT, how does this look? Alteryx can only deal with Dates in an ISO format (YYYY-MM-DD) so the first step just involves converting from your custom DD.MM.YYYY format. From there we can just group by the engagement/task/team and find the min/max of the start and end date respectively. After that, we just take a DateDiff in days and divide this by 7 to get days, flooring the calculation:

[binuacs · Accepted solution]

@OIT one way of doing this

[OIT]

@DataNath Many thanks! this worked perfectly for my scenario.