Re: Many to One Mapping

Home Page Forums BizTalk 2004 – BizTalk 2010 Many to One Mapping Re: Many to One Mapping

#23043

You need to implement explicit looping. Link something that only occurs once (preferably a parent to the E2EDS01GRP) into a looping functoid, then link that to the CTT node. This will limit it to one occurrence of the CTT.   It may be able to see the different SUMIDs if you are sourcing the loop iteration from a parent. 

If it can’t see both of the source nodes you need at run time, there are two methods to get the values:

1. One is to value map into a cumulative concatenate (this forces the if test across all occurrences in the document). 

2. The other is to cache the values to global variables in a scriptoid, and then extract the values from globals in two other scriptoids.