Hi All, I'm struck in coding below logic. Please help me out. I have input data set of products and their usage across time. I need an output in such a way that every overlapping of product usage needs to be seen as seperate record. PFB example. Input: ID beginning_date end_date product 1 01.01.2016 31.01.2016 A 1 10.01.2016 29.01.2016 B 1 15.01.2016 31.01.2016 C Output: Output ID beginning_date end_date Product 1 01.01.2016 09.01.2016 A 1 10.01.2016 14.01.2016 A+B 1 15.01.2016 29.01.2016 A+B+C 1 30.01.2016 31.01.2016 A+C Thanks alot.
... View more