This topic lists all the menu commands available in the Insert menu.
XML Schema / File
Adds to the mapping an XML schema or instance file. If you select an XML file which references a schema, no additional information is required for the mapping. If you select an XML file without a schema reference, you are prompted to generate a matching XML schema automatically (see Generating an XML Schema). If you select an XML schema file, you are prompted to include optionally an XML instance file which supplies the data for preview.
Adds to the mapping a database as source or target component (see Databases and MapForce).
Adds to the mapping a flat file document, such as CSV or a fixed-length text file. Both types of file can be used as source and target components. Insert Input
When the mapping window displays a mapping, this command adds an input component to the mapping (see Supplying Parameters to the Mapping). When the mapping window displays a user-defined function, this command adds an input component to the user-defined function (see Parameters in User-Defined Functions).
When the mapping window displays a mapping, this command adds an output component to the mapping. For details, see Returning String Values from a Mapping. When the mapping window displays a user-defined function, this command adds an output component to the user-defined function (see Parameters in User-Defined Functions).
Inserts a constant which supplies fixed data to an input connector. The data is entered into a dialog box when creating the component. You can select the following types of data: String, Number and All other.
Inserts an Intermediate Variable which is equivalent to a regular (non-inline) user-defined function. Variables are structural components, without instance files, and are used to simplify the mapping process (see Intermediate variables).
The Join component allows you to join data in SQL and non-SQL modes.
Inserts a component which allows you to sort nodes (see Sort Nodes/Rows).
Inserts a component that uses two input and output parameters: node/row and bool, and on-true, on-false. If the Boolean is true, then the value of the node/row parameter is forwarded to the on-true parameter. If the Boolean is false, then the complement value is passed on to the on-false parameter. For more information, see Filters and Conditions.
Inserts a component which allows you to filter database data conditionally. For more information, see SQL/NoSQL-WHERE/ORDER Component.
Inserts a component that transforms an input value to an output value using a lookup table. This is useful when you need to map a set of values to another set of values (for example, month numbers to month names). For more information, see Using Value-Maps.
Inserts a component of type If-Else Condition. For more information, see Filters and Conditions.
The exception component allows you to interrupt a mapping process when a specific condition is met. Please see Adding Exceptions for more information.