ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Alteryx Question: Breaking out a date range into multiple rows

taylor-detlefsen
5 - Atom

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 DateName1Name2

Name3

12/1/2512/5/25ABC123ABC123
7/1/257/2/25XYZ789XYZ789

 

Goal Outcome

DateStart DateEnd DateName1Name2Name3
12/1/2512/1/2512/5/25ABC123ABC123
12/2/2512/1/2512/5/25ABC123ABC123
12/3/2512/1/2512/5/25ABC123ABC123
12/4/2512/1/2512/5/25ABC123ABC123
12/5/2512/1/2512/5/25ABC123ABC123
7/1/257/1/257/2/25XYZ789

XYZ789

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

 

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

 

Thanks

1 REPLY 1
Hsandness
8 - Asteroid

@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 generate_rows_setup.jpgoutput.jpg

Labels
Top Solution Authors