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.
