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 |
Solved! Go to Solution.
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:
@OIT one way of doing this
@DataNath Many thanks! this worked perfectly for my scenario.