Skip to Content
0
Former Member
Aug 09, 2016 at 04:58 PM

Splitting a record into multiple records

1323 Views

Hi Experts,

We need to split a record into multiple records i.e. in multiple weeks based on the masterdata value.

This is because Event E1 starts from Week 36 to 41 and hence claim amount needs to be equally split into those weeks with extra cent going to the last week.

Is there some best modeling method to achieve this or we need to use SQL procedure to split a single record into multiple records ?

really appreciate your input on this topic.

Thanks,

Jomy

Attachments

Claims.JPG (37.8 kB)