Need to map records to a schema in sequence

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Need to map records to a schema in sequence

Viewing 0 reply threads
  • Author
    Posts
    • #18145

      Hi,

       I am facing a challenge where I have two very similar schemas both having sequence nodes with records in them, but when one is mapped to the other the resultant records are not in the sequence in which the original message is supposed to be.

      Here is the sample for the two schemas: (both the sequences are unbounded so they can have any number of records in the same sequence)

      Schema One

      <ns0:Root xmlns:ns0="http://Test.Decillion.BizTalk.SchemaGeneration.Schema_One"&gt;
        <Name>
          <Reference>Adam</Reference>
        </Name>
        <Age>
          <Reference>30</Reference>
        </Age>
        <DOB>
          <Reference>11-10-1977</Reference>
        </DOB>
        <Name>
          <Reference>Eve</Reference>
        </Name>
        <Age>
          <Reference>29</Reference>
        </Age>
        <DOB>
          <Reference>10-09-1966</Reference>
        </DOB>
      </ns0:Root>
       

      Schema Two

      <ns0:Root xmlns:ns0="http://Test.Decillion.BizTalk.SchemaGeneration.Schema_Two"&gt;
        <Name>
          <Reference></Reference>
        </Name>
        <Age>
          <Reference></Reference>
        </Age>
        <DOB>
          <Reference></Reference>
        </DOB>
        <Name>
          <Reference></Reference>
        </Name>
        <Age>
          <Reference></Reference>
        </Age>
        <DOB>
          <Reference></Reference>
        </DOB>
      </ns0:Root>
       

      I have a mapping defined between them which links each respective node to its corresponding node in the other schema. the end result is as follows:

       
      <ns0:Root>
      <Name>
       <Reference>Adam</Reference>
       </Name>
      <Name>
       <Reference>Eve</Reference>
       </Name>
      <Age>
       <Reference>30</Reference>
       </Age>
      <Age>
       <Reference>29</Reference>
       </Age>
      <DOB>
       <Reference>11-10-1977</Reference>
       </DOB>
      <DOB>
       <Reference>10-09-1966</Reference>
       </DOB>
       </ns0:Root>

       The above result is not what I had expected. what I wanted to get was each record in sequence after the other as follows:

       
      <ns0:Root>
      <Name>
       <Reference>Adam</Reference>
       </Name>
      <Age>
       <Reference>30</Reference>
       </Age>
      <DOB>
       <Reference>11-10-1977</Reference>
       </DOB>
      <Name>
       <Reference>Eve</Reference>
       </Name>
      <Age>
       <Reference>29</Reference>
       </Age>
      <DOB>
       <Reference>10-09-1966</Reference>
       </DOB>
       </ns0:Root>
       
      Can someone please guide me if I am doing something wrong, or if there is another way to get the result. Thanks.
       

Viewing 0 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.