Wednesday, July 7, 2010

BizTalk repeating source data view concurrently

Do you have multiple source data segments you wish to view concurrently?
Use the Cumulative Concatenate functoid. The trick is the second parameter. It is a number usually 2. This number tells the node (above the data) that you concatenate. So you do want get everything in the file.

1. Make sure to use a looping functoid on the node above your data. The node should have min 0 and max “*” or a value such as 99. This means it is a loop.
2. I use a script functoid before the Cumulative Concatenate functoid to add a delimiter to my array.
3. I used an iteration functoid and an equal function to suppress the extra records. Attach the equal to the target node you wish to suppress.
4. I loaded the concatenated data to a script functoid with other fields to calculate the results.

I wish I could post a picture here!!!