HCM Extract - EText Template - Looping

Summary

HCM Extract - EText Template - Looping

Content

Hi All,

I am using EText template for HCM Extract which results in Employee having Multiple Dependent.

The Requriement is to display the employee record along with each dependent details

Eg.If Employee has 2 child and spouse then my CSV output file should be like,

Employee,.,.,Child1,.,.,Spouse,Address

Employee,.,.,Child2,.,.,Spouse,Address

My XML structure is like:

<Main_Block>

<Emp_Record>

...Employee Details..

</Emp_Record>

<Dependent_Block>

<Dependent_Record>

...Dependent Details..

</Dependent_Record>

</Dependent_Block>

<Spouse_Traverse>

<Spouse_Block>

<Spouse_Record>

..Spouse Details.

</Spouse_Record>

</Spouse_Block>

</Spouse_Traverse>

<Address_Traverse>