Tallan's Blog

Tallan’s Experts Share Their Knowledge on Technology, Trends and Solutions to Business Challenges

Posts Tagged "BizTalk Mapping"

Why the 100 Parameter Limit in the BizTalk Table Looping Functoid Shouldn’t Matter

If you have ever used the Table Looping functoid in a BizTalk map, then you’re aware of its ability to take multiple inputs (whether they’re links from a source schema or other functoid outputs), and configure them as a table looping grid, so that these values can be used to create multiple nodes in the destination schema.  Essentially, this functoid can be used to unpivot repeating or flattened data into multiple nodes.
For example, in the mapping below, I’m taking a flat file that has repeating fields to represent ten Line Items, all on a single record.  Using the Table Looping functoid, I can map these repeating fields to create multiple LineItem records in my destination.