Transpose with Date Ranges in Columns

[amevy]

I am trying to transpose a file based on date ranges in columns such that there is unique record for each date.  Files are as below.  Here is where i am at

1. Convert dates to Alteryx format

2. Determine the difference in the dates 

3. How do i create additional records for each date?

Any help appreciated

Input
invoice	Product	Start Date	End Date
1	A	Jan/1/2019	Jan/4/2019
1	B	Feb/1/2018	Feb/3/2018
2	A	Jun/15/2017	Jun/20/2017
Output		Date
1	A	Jan/1/2019
1	A	Jan/2/2019
1	A	Jan/3/2019
1	A	Jan/4/2019
1	B	Feb/1/2018
1	B	Feb/2/2018
1	B	Feb/3/2018
2	A	Jun/15/2017
2	A	Jun/16/2017
2	A	Jun/17/2017
2	A	Jun/18/2017
2	A	Jun/19/2017

[Jean-Balteryx · Accepted solution]

Hi @amevy ,

I attached a workflow doing what you want using the Generate Rows tool.

Don't hesitate if you have questions or need more details.

Kind regards,

Jean-Baptiste

[Jean-Balteryx]

Hi @amevy ,

Did it solve your problem ?

Cheers,

Jean-Baptiste

[amevy · Accepted solution]

I guess better late than never , yes it did the job perfectly thank you for the help!