Split the dates between the Date Intervals as separate rows

[samkp]

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

[patrick_digan · Accepted solution]

I would use the generate rows tool. Update start date field. Initialize with start date field. Condition is start date < stop date. Loop expression will be using the datetimeadd function to add 1 month( or whatever formula fits your needs)

If your fields aren't coming in as alteryx dates ("yyyy-mm-dd") then you may want to use the date time tool to convert them.

[SeanAdams · Accepted 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

[samkp]

thank you. that helped me. It's Solved.