Consolidate XML data to contain particular employee data

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>