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

Consolidate XML data to contain particular employee data

Accepted answer
5
Views
1
Comments
edited Jan 3, 2019 12:24PM in Integration 1 comment

Content

Hi All,
I need to consolidate a set of XML employee data in OIC. I have tried using for-each activity but the problem is it has the limitation of 5000 records and my process may receive more than 5000 records.
 
Below is an example of my input data and expected output. 
 
Input XML:
 
<Employee>
     <EmployeeName>John</EmployeeName>
     <EmployeeID>123</EmployeeID>
     <EmployeeSkillSet>OSB</EmployeeSkillSet>
<Employee>
<Employee>
     <EmployeeName>John</EmployeeName>
     <EmployeeID>123</EmployeeID>
     <EmployeeSkillSet>ICS</EmployeeSkillSet>
<Employee>
<Employee>
     <EmployeeName>John</EmployeeName>
     <EmployeeID>123</EmployeeID>
     <EmployeeSkillSet>SOA</EmployeeSkillSet>
<Employee>
<Employee>
     <EmployeeName>Sara</EmployeeName>
     <EmployeeID>456</EmployeeID>
     <EmployeeSkillSet>Java</EmployeeSkillSet>
<Employee>
<Employee>
     <EmployeeName>Sara</EmployeeName>
     <EmployeeID>456</EmployeeID>
     <EmployeeSkillSet>Spring</EmployeeSkillSet>

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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