Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Need to map records to a schema in sequence
- This topic has 0 replies, 1 voice, and was last updated 9 years, 10 months ago by
community-content.
-
AuthorPosts
-
-
October 4, 2007 at 6:19 PM #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">
<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">
<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.
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.