Skip to Content
avatar image
Former Member

Regarding Multiple Mapping

Hello

Can i do mappings from multiple source headers to one target header. I am providing a simple example below so as for people to understand it better.

<Name>

<FirstName></FirstName>

<LastName></LastName>

<MiddleName></MiddleName>

</Name>

<Address>

<FirstLine></FirstLine>

<SecondLine></SecondLine>

</Address>

<Address>

<FirstLine></FirstLine>

<SecondLine></SecondLine>

</Address>

<Address>

<FirstLine></FirstLine>

<SecondLine></SecondLine>

</Address>

<Name>

<FirstName></FirstName>

<LastName></LastName>

<MiddleName></MiddleName>

</Name>

<Address>

<FirstLine></FirstLine>

<SecondLine></SecondLine>

</Address>

<Address>

<FirstLine></FirstLine>

<SecondLine></SecondLine>

</Address>

<Address>

<FirstLine></FirstLine>

<SecondLine></SecondLine>

</Address>

Consider the above sequence of XML and suppose the address fields have to appear in the target destination do i need to map the address header also to the target header.And if i need to map it what is the design for the mapping.Or is there some other solution.

Thanks and Regards

Sharat

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 28, 2005 at 11:03 AM

    Hi

    Create ur data type as follows

    <Name> with Ocurrance 1

    <FirstName></FirstName>

    <LastName></LastName>

    <MiddleName></MiddleName>

    </Name>

    <Address> with Occurance 1...Unbounded

    <FirstLine></FirstLine>

    <SecondLine></SecondLine>

    </Address>

    And do same in the target structure and map like this

    <Name>-- <Name>

    <Address>--<Address>

    Regards

    Arpit Seth

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Arpit

      But in my case i have only one target header field which is named as Info for example.

      <Info>

      </Info>

      So what do i do in this case since i have mapped the Name header to the Info header and done a split by value with the value changed. So what happens in my case is that the address field which has been mentioned multiple times appears only once in the Info part.So if i have two Name and six Address headers as mentioned in the example i am able to see only two names and two address infos.What about the rest four of the address fields which contains some information.

      Thanks and Regards

      Sharat