Edit

Table-Driven Looping Configuration

  • Article

Follow these steps to configure table-driven looping in your map:

  • Add a Table Looping functoid to the map. You need only one Table Looping functoid per table-driven looping instance. For example, if you are using table-driven looping to derive BillTo and ShipTo information, you need only one Table Looping functoid in your map. However, if you are using table-driven looping to derive BillTo and ShipTo information and StoreName and StoreAddress information, you might need two Table Looping functoids in your map.

  • Add one more Table Extractor functoid to the displayed grid page. Add as many Table Extractor functoids as you need for each Table Looping functoid. The number of Table Extractor functoids depends on the number of fields in the destination schema. For example, if you only have an AddressCode in your source schema and CompanyName, Address, City, State, PostalCode, and AttentionName in your destination schema, you need to add six Table Extractor functoids to the displayed grid page.

  • Configure the Table Looping functoid with the appropriate inputs. First, link the Table Looping functoid to the input instance record or element. Also link it to the structure in the output instance message. Next, configure the inputs by using the Configure <Functoid> Functoid dialog box. For more information about how to configure this property, see Editing Functoid Properties and Input Parameters . The list of inputs you enter must be comprehensive and complete because this is the data that you will use to configure the Table Functoid Grid property. The inputs must be defined as follows:

    • First input. The first input parameter is the link to the input instance message record or field. The Table Looping functoid loops once for each instance of the record or field.

      Note

      This is a required input.

    • Second input. The second input parameter defines the number of columns in the looping grid. The grid may contain up to 228 columns.

      Note

      This is a required input.

    • Remaining inputs. The remaining inputs for the Table Looping functoid consist of a list of all of the possible values that may appear in the Table Functoid Grid.

      Note

      Labeling links is very helpful. Without labels, links appear in the Table Functoid Grid as fully specified paths.

      For step-by-step instructions about how to configure inputs for the Table Looping functoid, see How to Add Table Looping and Table Extractor Functoids to a Map. In particular, see steps 3 through 8.

  • Configure the Table Functoid Grid property of the Table Looping functoid. Use the Table Functoid Grid property to open the Configure Table Looping Functoid dialog box in which you configure the cells in the looping grid.

    For step-by-step instructions about how to configure the looping grid, see How to Add Table Looping and Table Extractor Functoids to a Map. In particular, see steps 9 and 10.

  • Configure the Table Extractor functoids. Use the Input Parameters property to configure the Table Extractor functoid inputs as follows:

    • First input. The first input parameter to a Table Extractor functoid is the Table Looping functoid.

    • Second input. The second input parameter specifies the column in the row from which to extract data.

      For step-by-step instructions about how to configure the Table Extractor functoids associated with a Table Looping functoid, see How to Add Table Looping and Table Extractor Functoids to a Map. In particular, see steps 11 through 16.

See Also

Table Looping Functoid
Table Extractor Functoid
Table-Driven Looping Example
How to Add Table Looping and Table Extractor Functoids to a Map
Advanced Functoids
Index Functoid
Iteration Functoid
Looping Functoid
Record Count Functoid