HDL Transformation Formula Non Recurring Entry issue

Summary

Multiple Entry Count issue when we have two records for same element in a single file

Content

Hi Team,

 

We have a requirement to load non-recurring elements through HDL transformation fast formula.

 

We are aware that for non-recurring elements we have to increament the MultipleEntryCount by 1 for each entry, for this we have a logic to increament after getting max entry from system.

 

But the issue we are facing is input file contains two entries for each element with effective date from 1st and from 15th of each month,
as we get 2 entries in a single file we are getting below error.