Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > Multiple elements to single element mapping
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 28th April 14:18
shahidazim78
External User
 
Posts: 1
Default Multiple elements to single element mapping



I have an XML do***ent like this:

<MyDates>
<Date Type="Do***ent">20040923</Date>
<Date Type="Despatch">20040924</Date>
</MyDates>

And I want to map the above do***ent to the following do***ent:

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

Here

Type="Do***ent" -> <OrderEntryDate>
Type="Despatch" -> <DespatchDate>

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


  sponsored links


2 28th April 14:18
tanbn
External User
 
Posts: 1
Default Multiple elements to single element mapping



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.

--------------------

15:43:36 GMT)

cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFT NGP08.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
  Reply With Quote
3 28th April 14:18
matt milner
External User
 
Posts: 1
Default Multiple elements to single element mapping


You can also use the value mapping funtoids. Take a look at the examples in
the do***entation to see which one works for you (I can never keep the two
straight). Essentially you use this with a logical functoid to say that if
the Type=Do***ent, map it to this element, and if the type = Despatch, map
it here. This way you are not tied to having those things come in a
particular order in your do***ent.

Matt
  Reply With Quote
Reply


Thread Tools
Display Modes




Copyright © 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666