Alteryx Question: Breaking out a date range into multiple rows

Question

Hi Alteryx Community!

I am trying to find a way to edit my data in Alteryx.  The goal is to break out a date range into multiple columns.  The data I am working with has a Start date column and an end date column.  There are names and other dimensions associated for each row.  I would like to essentially duplicate each of the rows, for each individual date in the range.

Example:

Original Data

Start DateEnd DateName1Name2Name3

12/1/2512/5/25ABC123ABC1237/1/257/2/25XYZ789XYZ789

Goal Outcome

DateStart DateEnd DateName1Name2Name312/1/2512/1/2512/5/25ABC123ABC12312/2/2512/1/2512/5/25ABC123ABC12312/3/2512/1/2512/5/25ABC123ABC12312/4/2512/1/2512/5/25ABC123ABC12312/5/2512/1/2512/5/25ABC123ABC1237/1/257/1/257/2/25XYZ789XYZ789

7/2/257/1/257/2/25XYZ789XYZ789

If anybody has any insight on how to get this result, I would appreciate it!!

Thanks

Hsandness · Answer

@taylor-detlefsen

You should be able to accomplish what you need with just the Generate Rows tool. See the screenshots below and let me know if you have questions.

sen