List creation in Graphical mapping

[Former Member]

Hi Experts,

I have a requirement when source side have multiple fields, all having 0..1 occurrence and target side I have list of two fields with 0...unbounded occurrence where value of second field is constant and value of first field will be determined from source structure, how I can achieve this. I have checked multiple threads but they all are from same field  by changing context and other things but not with multiple fields to a list.

Source structure :

<Header>

   <Item 1>ABC </Item 1>

   <Item 2>DEF</Item 2>

   <Item 3>GHI </Item 3>

   <Item 4>JKL</Item 4>

</Header>

Target Structure :

<Line Items>

    < Line Item>

        <Name>ABC</Name>

        <ID code> 12</ID Code>

     </Line Items>

   < Line Item>

        <Name>DEF</Name>

        <ID code>34</ID Code>

     </Line Items>

    < Line Item>

        <Name>GHI</Name>

        <ID code> 56</ID Code>

     </Line Items>

    < Line Item>

        <Name> JKL</Name>

        <ID code> 78 </ID Code>

     </Line Items>

</Line Items>

Regards,

Naveen K

[markangelo_dihiansan]

Hi Naveen,

Here you go Take note of the imports

Testing

Regards,

Mark

[former_member190293]

Hi Naveen!

If your source message fields have fixed number and names you can simply duplicate destination node in graphical mapping as many times as many source fields you have and map each of source fields to its own destination node item.

Regards, Evgeniy.

[Harish]

Hi Naveen,

You need to use the UDF to map multiple source field to one target field. please refer the below thread

How to map multiple source fields to single&amp;nbs... | SCN

Mapping multiple source field to one target | SCN