I need to split one line item in years between two dates and make rows based on the years

[Mahesh6279]

Turn one row into 4 rows based on the start and end year

[ed_hayter]

generate rows is the tool to use here. For your example you will want to add a year on in your date time add

we create a new field date, and use the start date as our initial expression. New field date is less than or equal to end date is our condition for it to keep running. I.e. stop when date is past end date. And the expression to loop is a datetime add where we add a day to our date each loop.

[PhilipMannering]

Hi @Mahesh6279 

The generate rows tool should help here,

[FrederikE]

Hey @Mahesh6279,

This is one way to do it: 

This ensures that Start and End are kept from the original dataset.

[Mahesh6279]

Thank you for the reply, I need the End date to reflect the 12-31 of the same year it started. Example in 2021 it started from 1-1-2021 and ends in 12/31/2021. Appreciate you help.

[FrederikE · Accepted solution]

Hey @Mahesh6279,

You can just subtract a day again in a similar fashion as the proposed solutions. See the attached WF. 

[Mahesh6279]

Worked like charm. Thank you for the support