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 |
Solved! Go to 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
I guess better late than never , yes it did the job perfectly thank you for the help!