Hello Alteryx community,
I have some data describing the length of production runs on a production line. So one column specifies the line, the second column specifies the completion date of the production run, and the third column specifies the length in days of the production run.
I need to convert this into a by-day schedule of when the line was run. So one column would specify the line just like before, but the second column would specify a single day, and the third column would specify the proportion of the day that the line was run (i.e., maximum = 1).
I've attached an xls illustrating the data I have to start with and what I'd like to end with. I feel like the Generate Rows tool should work but I can't get it to work quite right.
Thank you for reading and for any help you can provide.