Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Duplicate entries based on dates

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


0 Replies