AnsweredAssumed Answered

I have a scenario where I need to combine the multiple records into a single record which has different start date and end dates

Question asked by palle842125 on Mar 21, 2018
Latest reply on Mar 23, 2018 by nanadar676191

For Example

7700,2001,10000002,20171226,20171226,1100, ,0000100,000000,2050, ,18A29,0000000001
7700,2001,10000002,20171227,20171227,1100, ,0000100,000000,2050, ,18A29,0000000002
7700,2001,10000002,20171228,20171228,1100, ,0000100,000000,2050, ,18A29,0000000003
7700,2001,10000002,20171229,20171229,1100, ,0000100,000000,2050, ,18A29,0000000004
7700,2001,10000002,20180108,20180108,1198, ,0000100,000000,2050, ,18A29,0000000005
7700,2010,10000002,20180131,20180131, ,2154,0000000,007150,2050, ,18A29,0000000006

 

The first 4 records which has time type 1100 needs to be combined for consecutive dates. So all that 4 records should be combined to single record with different end date and the value should be 4 instead of one.

 

There should be only 3 records as below

7700,2001,10000002,20171226,20171229,1100, ,0000400,000000,2050, ,18A29,0000000001

7700,2001,10000002,20180108,20180108,1198, ,0000100,000000,2050, ,18A29,0000000005
7700,2010,10000002,20180131,20180131, ,2154,0000000,007150,2050, ,18A29,0000000006

Outcomes