mapper - multiple loops to a single destination

From: Rick (Rick.1icz11_at_mail.webservertalk.com)
Date: 01/04/05 

Date: Tue, 4 Jan 2005 15:08:33 -0600

Hi,
I am trying to find a way in the BizTalk 2004 mapper to do multiple
loops from different groups of source nodes and then conditionally map
certain child nodes - all to the same destination node group in the
destination schema.

In other words - in my source schema I have lots of source nodes, some
that occur once, and some that occur multiple times. In my destination
schema, I have a node with many children.

The problem that I have is how to: (for each group of nodes in the
destination schema), loop through a group of nodes, and find the record
where a specific child node's value meets a condition, and then map one
of it's sibling node's values to its destination. Also, there are many,
many mappings to be done like this within the same node group.

Note that I can do this kind of thing if there is only one looping and
one condition, but when I try to map multiple looping functoids (each
with multiple conditions) to a single destination, I cannot find any
success. (this is obviously the part where i am mapper challenged!)

this sample input and output xml tries to illustrate the problem:

<SourceInput>
<Group1>
<Node>
<A>Not TheOne</A>
<B />
</Node>
<Node>
<A>TheOne</A>
<B>Because the value of sibling node A is 'TheOne', map this
node to the Destination node that is named 'TheOneForB'</B>
</Node>
</Group1>
<Group2>
<Node>
<C>AnotherOne</C>
<D>Because the value of sibling node C is 'AnotherOne', map
this node to the Destination node that is named 'TheOneForD'</D>

</Node>
<Node>
<C>Not AnotherOne</C>
<D />
</Node>
</Group2>
</SourceInput>

<DestinationOutput>
<TheOneForB>data from the B node from Group1 where B node's
sibling node A has value 'TheOne'</TheOneForB>
<second />
<TheOneForD>data from the D node from Group2 where D node's
sibling node C has value 'AnotherOne'</TheOneForD>
<fourth />
<fifth />
</DestinationOutput> 

--
Rick
------------------------------------------------------------------------
Posted via http://www.webservertalk.com
------------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message863216.html

Relevant Pages

  • Re: file copier with log
    ... and the destination directory. ... A colleague suggested that i map the source directory, too, and map ... need to log in an .mdb the source path, destination path, drive ... Sub xerox ...
    (microsoft.public.scripting.vbscript)
  • Re: Question on Effective Java Item 27
    ... value to convey multiple meanings. ... Because I haved programmed in different prog langs, ... Returns the value to which the specified key is mapped in this identity hash map, or null if the map contains no mapping for this key. ... A return value of null does not necessarily indicate that the map contains no mapping for the key; it is also possible that the map explicitly maps the key to null. ...
    (comp.object)
  • Re: Message appearence in a Trasformation Shape
    ... destination and when the i click ok it will open the map, just like you make it a drag Trasform shape and you specify every thing in the Transform Shape in the orchesteration view ... Have you selected an existing map? ... corresponds with the maps source schemas type and/or destination ... Private blog: http://blog.eliasen.dk ...
    (microsoft.public.biztalk.general)
  • Re: Need help making a decision on gps purchase
    ... The zumos are motorcycle oriented but will work equally well in a car. ... If you pay attention to the numbers of waypoints and routes allowed on the different models, that will be your indicator of the multiple destination capability. ...
    (sci.geo.satellite-nav)
  • Re: Mapping multiple search result messages to a consolidated search result - possible?
    ... SearchResultB ---+ ... I can't work the functoids to do this - I can map a single part (say ... SearchResultA) to ConsolidatedSearchResult but cant combine multiple to one ... > Do you want to combine multiple XML messages into a single XML message? ...
    (microsoft.public.biztalk.general)
Quantcast