Hi,
I am trying to find a way in the BizTalk 2004 mapper to do multiple loops fr
om 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 destinati
on schema), loop through a group of nodes, and find the record where a speci
fic child node's value meets a condition, and then map one of it's sibling n
ode's values to its destination. Also, there are many, many mappings to be d
one like this within the same node group. 


Note that I can do this kind of thing if there is only one looping and one c
ondition, but when I try to map multiple looping functoids (each with multip
le 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 t
o 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 no
de 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>

[ Post a follow-up to this message ]

Hi Rick,
I too had similar problem, but was able to solve once I updated my
output schema. Check your output schema if it supports multiple loops
(MaxOccur=unbounded).

"Rick" wrote:

>
> 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
>
>

[ Post a follow-up to this message ]