I'm attempting to create an iterative macro that splits time intervals into two separate intervals and then repeats the process until each time intervals doesn't cross a certain threshold. I am new to the macro scene but modeled my workflow after the iterative macro tutorial in Alteryx's self-paced training section. The macro works but only goes through one iteration and doesn't show both lines that were split into one, only the first line.
I attached the macro workflow and small subset of data that I'm working with. It is production data for a manufacturing facility where each event is defined with a start and end datestamp. I want to split this time interval if it crosses over into the next day's shift start time (which is adjusted since it is not midnight). The iterative aspect kicks in because some events span over multiple days so I would like to continue to split a time interval until they all represent a unique shift date.
