Duplicate entries based on dates

Wed, 29 May 2013 14:57:29 GMT

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

topic Duplicate entries based on dates in QlikView