Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Record for each date from start date to end date

kevinbird15
9 - Comet

What I'm trying to do is take a record that looks like this: 

Start_DT End_DT

Unit_ID

2013-04-05 2013-04-09 1

 

and change it to look like this: 

 

Record_DT Unit_ID

2013-04-05

1
2013-04-06 1
2013-04-07 1
2013-04-08 1
2013-04-09 1

 

Is this possible with Alteryx?  I have had a difficult time making this work.  Any help would be appreciated.  Currently I don't have any ideas that would make this work.  One thing I thought about is that I could calculate how many dates were between the start and end date and then add N records, but I'm not sure how I could do this in Alteryx.  

 

Thanks again.  

10 REPLIES 10
rajm
5 - Atom

Kevinbird15, Thank you for sending this. 

Labels