BizTalk Server Tools - Multiple elements to single element mapping

Author

Multiple elements to single element mapping

Shahid Azim

2004-09-23, 5:51 pm

I have an XML document like this:

<MyDates>
<Date Type="Document">20040923</Date>
<Date Type="Despatch">20040924</Date>
</MyDates>

And I want to map the above document to the following document:

<NewDates>
<OrderEntryDate>20040923</OrderEntryDate>
<DespatchDate>20040923</OrderEntryDate>
</NewDates>

Here

Type="Document" -> <OrderEntryDate>
Type="Despatch" -> <DespatchDate>

I have tried with looping functoid but its not working. So any suggestion?

Tan Bao Nguyen

2004-09-23, 5:51 pm

In the output below, should it be (note the DespatchDate value):

<NewDates>
<OrderEntryDate>20040923</OrderEntryDate>
<DespatchDate>20040924</OrderEntryDate>
</NewDates>

If so, use two index functoid; link the first index functoid (with an index
value of 1) to the OrderEntryDate field and the second index functoid (with
an index value of 2) to the DespatchDate field.

Regards,
Tan Nguyen
Microsoft BizTalk Server

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------[vbcol=seagreen]
15:43:36 GMT)[vbcol=seagreen]
cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!p
ostnews1.google.com!not-for-mail[vbcol=seagreen]