AnsweredAssumed Answered

How to insert 3 different data structures into one xml file based on one unique Id

Question asked by srkumar035547 on Dec 19, 2016
Latest reply on Jan 9, 2017 by Adam Arrowsmith

Having a DB profile as inbound, from there I'm receiving same set of data with three different fields. Now I need to generate a single xml with multiple child tags.

For Eg:

100, abc, 35k
100, xyz, 40k
100, xxx, 50k

Expecting Output:

<ID>
<EMP>
<EMPID>100</EMPID>

<EMP>
<Project>
<ProjectName>abc</ProjectName>
<Salary>35k</Salary>
</Project>
<Project>
<ProjectName>xyz</ProjectName>
<Salary>40k</Salary>
</Project>
<Project>
<ProjectName>xxx</ProjectName>
<Salary>50k</Salary>
</Project>
</ID>

Outcomes