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 Date | End Date | Name1 | Name2 | Name3 |
| 12/1/25 | 12/5/25 | ABC | 123 | ABC123 |
| 7/1/25 | 7/2/25 | XYZ | 789 | XYZ789 |
Goal Outcome
| Date | Start Date | End Date | Name1 | Name2 | Name3 |
| 12/1/25 | 12/1/25 | 12/5/25 | ABC | 123 | ABC123 |
| 12/2/25 | 12/1/25 | 12/5/25 | ABC | 123 | ABC123 |
| 12/3/25 | 12/1/25 | 12/5/25 | ABC | 123 | ABC123 |
| 12/4/25 | 12/1/25 | 12/5/25 | ABC | 123 | ABC123 |
| 12/5/25 | 12/1/25 | 12/5/25 | ABC | 123 | ABC123 |
| 7/1/25 | 7/1/25 | 7/2/25 | XYZ | 789 | XYZ789 |
| 7/2/25 | 7/1/25 | 7/2/25 | XYZ | 789 | XYZ789 |
If anybody has any insight on how to get this result, I would appreciate it!!
Thanks
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
