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