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