Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
HCM Extract - EText Template - Looping — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

HCM Extract - EText Template - Looping

Received Response
58
Views
7
Comments
edited Aug 17, 2018 3:49PM in HCM Integrations 7 comments

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>

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!