How to split the range of leave records into separate rows?
Example : Absence Record with leave start date from Jan 1st to Jan 3 exist .
Extract is created to pull the absence details.Extract pulls the absence record with Absence Start date and End date . But having a requirement to create separate rows for range of leave.
From example : we need to create 3 separate rows for JAn 1 , Jan 2 , Jan 3 and integrated through OIC .
Any way to split up the records at extract level
Thanks,
Chintha