cancel
Showing results for 
Search instead for 
Did you mean: 

Mapping issue in PO

das_sappo
Participant
0 Kudos

Dear Experts,

I have to create the output xml from the below source XML. For each <Records> there will be one <Items> segment in the target and for the same <ID> value in source <Line> segment needs to be populated in the target.

Number of <ID> field having same value equals to no of <Line> segments.

Source XML

<strong><Documents>
 <Records>
  <Name>Rayan</Name>
  <ID>1001</ID>
 </Records>
 <Records>
  <Name>Mark</Name>
  <ID>1001</ID>
 </Records>
 <Records>
  <Name>Javi</Name>
  <ID>1002</ID>
 </Records>
 <Records>
  <Name>Karim</Name>
  <ID>1002</ID>
 </Records>
 <Records>
  <Name>David</Name>
  <ID>1002</ID>
 </Records>
</Documents><br></strong>


Target XML

<strong><Documents>
  <Items>
    <Name>Rayan</Name>
    <Line>
      <ID>1001</ID>
    </Line>
    <Line>
      <ID>1001</ID>
    </Line>
  <Items>
  <Items>
    <Name>Mark</Name>
    <Line>
      <ID>1001</ID>
    </Line>
    <Line>
      <ID>1001</ID>
    </Line>
  <Items>
   <Items>
    <Name>Javi</Name>
    <Line>
      <ID>1002</ID>
    </Line>
    <Line>
      <ID>1002</ID>
    </Line>
    <Line>
      <ID>1002</ID>
    </Line>
  </Items></strong>
<strong><Documents></strong>
das_sappo
Participant
0 Kudos

Please suggest how can I achieve this

Accepted Solutions (0)

Answers (0)