Split record with start and end date and duration in to multiple records

msmt85

Hi all,

Am not sure how to work out the next example but assume need to do something with the generate rows function.

Example table with 1 record:

Start Date - End Date - Duration in days

1.  2019-04-19 - 2019-05-13 - 25 days

Expected table where record 1 is being split in to 2 months with duration for each month:

Month - Duration

1. 2019-04-1 - 12

2. 2019-05-1 - 13

How to achieve this with minimum logic? Suggestions / solutions are more then welcome.

JoshuaGostick

Hi @msmt85,

I've built a workflow that should hopefully help with your issue. What I did was use the Generate Row tool to generate the days from the start date to the end date. Then, I used the Summarize tool to count the number of days in each month.

Let me know if you have any questions.

Thanks,

Josh

Split record with start and end date and duration in to multiple records.yxmd