Wednesday, September 1, 2010

Table Looping and Table Extractor Functoid in BizTalk

In my recent project I had two requirements for mapping
1.    Map fixed number of elements from source to repeating elements in the destination message.
2.    And Map only if  the value in one of the element exists

Solution: Table Looping and Table Extractor Functoid

Here is a good blog post on using Table Looping and Table Extractor functoid that I referred.
http://hestia.typepad.com/flatlander/2007/01/mapping_fixed_e.html

In order to satisfy the requirement number 2 above I used the Not Equal functoid and connected it to the table looping functoid. Under Configure Table Looping Grid used the output from Not Equal functoid as Column 1 and checked the gated checkbox.

The configure table looping grid looks like below

No comments:

Post a Comment