Biztalk mapping from a repeating structure to a flat structure

estranda posted on Thu, Jul 2 2009 12:19 PM

rated by 0 users

Hi!

I have a problem I thought would be easy to solve. I need to map one value from a repeating structure over to a flat one. I have an in schema with a structure like this (Short sample)

<Message>
Version
Id
<OtherIdentifications>
Identification
Type
</OtherIdentifications>
<Message>

And out schemas with a structure like this:

<Schema>
Version
Id  
OldId
</Schema>

“OtherIdentifications” has many rows, and I need to map one specified value over to the “OldId”. I have managed to do it with use of “Cumulative Concatenate” and more “functoids”, but this gets really slow for bigger messages. I have also tried “Equal” and a “Value mapping”, and that works if the value I want is the first, and that is not always the case. I wanted to use Table looping, but since I don’t have a field to connect the "Table looping" to in the out schema, I’m not able to iterate thru it. It would be wrong to connect to the since that is used for each .

I guess this is a pretty normal thing to do, so it’s frustrates me not to find a quick solution, any help would be gratefully :)