Hi there,
I'm looking for a way of splitting a list based on the DEnd date.
When the DEnd is different to the DStart, I need to create one entry by month covered by incidents.
INPUT
SET TimestampFormat = 'M/D/YYYY';
LOAD * INLINE
Incident, DStart, DEnd, Business impacted
Incident 1, 1/10/2013, 2/10/2013, Layers
Incident 2, 1/1/2013, 4/2/2013, Hotliners
];
OUTPUT
Incident, DStart, DEnd, Business impacted
Incident 1, 1/10/2013, 1/31/2013 Layers
Incident 1, 2/1/2013, 2/10/2013 Layers
Incident 2, 1/1/2013, 1/31/2013, Hotliners
Incident 2, 2/1/2013, 2/30/2013, Hotliners
Incident 2, 3/1/2013, 3/31/2013, Hotliners
Incident 2, 4/1/2013, 4/2/2013, Hotliners
Hope the output is clear enough.
Thanks in advance
