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! EngagementTaskTeamstart dateEnd dateXYZCOMA20.01.202418.02.2024ABCARGC21.02.202418.03.2024IJKNPB20.07.202418.08.2024ABCARGC29.03.202418.04.2024ABCARVC15.06.202410.07.2024 Output EngagementTaskTeamstart dateEnd dateNumber of weeksXYZCOMA20.01.202418.02.20244ABCARGC21.02.202418.04.20248IJKNPB20.07.202418.08.20244ABCARVC15.06.202410.07.20243

Combining rows with matching conditions

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

Fuzzy Match

Accepted answers

binu_acs

@OIT one way of doing this

Combine_Row_04122023.yxmd

All comments

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:

Combine rows and calculate no. of weeks.yxmd

binu_acs

@OIT one way of doing this

Combine_Row_04122023.yxmd

OIT

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

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335