I have data
Member | START_DT | STOP_DT |
M1 | 5/1/2014 | 8/1/2014 |
I want to split the records as below
Member | START_DT | STOP_DT |
M1 | 5/1/2014 | 8/1/2014 |
M1 | 6/1/2014 | 8/1/2014 |
M1 | 7/1/2014 | 8/1/2014 |
Solved! Go to Solution.
Hey @samkp
This is definately possible - there's a great post by @ChadM here on how to do something very similar using Generate Rows tool
https://community.alteryx.com/t5/Data-Preparation-Blending/Generate-Date-values/td-p/233
Essentially what you want to do is generate multiple new start dates, 1 month apart, starting from the provided start date, and ending when the start date > Stop date
Have a look at Chad's post, and if you're still stuck, we can help to mock this up
Cheers
Sean
thank you. that helped me. It's Solved.