How to Add Value Mapping (Flattening) Functoids to a Map
The Value Mapping (Flattening) functoid enables you to flatten a portion of an input instance message by converting multiple records into a single record. This is a common operation in converting Microsoft Commerce Server catalogs.
For conceptual information about the Value Mapping (Flattening) functoid, see Value Mapping (Flattening) Functoid.
To add the Value Mapping (Flattening) functoid to a map and configure it
With the Visual Studio Toolbox active, click the Advanced Functoids tab to select that category of functoids.
The list of advanced functoids in the chosen category appears.
Drag the Value Mapping (Flattening) functoid () from the Toolbox to the appropriate location on a grid page.
Note
The functoid will be placed on the displayed grid page. If you want to put the functoid onto a different grid page, you need to display that other grid page first.
Note
If you are constructing a map using more than one functoid together, you need to consider their relative left to right placement. Functoids are executed from left to right. The output of a functoid can only be input to another functoid that is farther to the right.
To establish the first input parameter for the Value Mapping (Flattening) functoid, create an input link by dragging the Value Mapping (Flattening) functoid to a record or field node in the source schema, or to another functoid to its left, that has a Boolean data type and that will produce an input value of "true" or "false."
Note
You can also drag in the opposite direction, dragging the source of the Boolean value to the Value Mapping (Flattening) functoid.
To establish the second input parameter for the Value Mapping (Flattening) functoid, create an input link by dragging the Value Mapping (Flattening) functoid to a record or field node in the source schema, or by dragging a record or field node in the source schema to the Value Mapping (Flattening) functoid, or insert a constant.
Note
The second input parameter to the Value Mapping (Flattening) functoid can also be from the output of another functoid to its left. Create the links the represent such sources of input by dragging one of the relevant functoids to the other relevant functoid.
To use the output parameter from the Value Mapping (Flattening) functoid, create an output link by dragging the Value Mapping (Flattening) functoid to a record or field in the destination schema, or by dragging a record field in the destination schema to the Value Mapping (Flattening) functoid.
Note
As with other functoids, the output of the Value Mapping (Flattening) functoid can be used as input to another functoid.