Turn one row into 4 rows based on the start and end year
Hey @Mahesh6279,
You can just subtract a day again in a similar fashion as the proposed solutions. See the attached WF.
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.
Hi @Mahesh6279
The generate rows tool should help here,
This is one way to do it:
This ensures that Start and End are kept from the original dataset.
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.
