Insert
This topic lists all the menu commands available in the Insert menu.
| You can add components via the Component Gallery. The Gallery provides an overview of the available sources, targets, and data-processing components. You can also access the Component Gallery via the  
 | 
| Adds an XML schema or instance file to the mapping. If you select an XML file without a schema reference, MapForce can generate a matching XML schema. If you select an XML schema file, you are prompted to include an XML instance file which supplies the data for preview. You can also add an XML/XSD file via the  
 | 
| Adds a JSON schema or file. For details, see JSON. You can also add a JSON component via the  
 | 
| Adds a database component. You can also add a database component via the  
 | 
| Adds a flat file document such as CSV or a fixed-length text file. For details, see CSV and Text Files. You can also add a text file via the  
 | 
| Adds a Microsoft Excel 2007+ (.xlsx) file. See Microsoft OOXML Excel 2007+.  If you do not have Excel 2007+ installed on your machine, you can still map to or from Excel 2007+ files. In this case, you cannot preview the result in the Output pane, but you can still save the result. You can also add an Excel file via the  
 | 
| Adds a PDF document.You can also insert a PDF document via the toolbar. For more information, see PDF. 
 | 
| Adds an EDI document. You can also add an EDI component via the  
 | 
| Adds an XBRL instance or taxonomy document. You can also add an XBRL component via the  
 | 
| Adds a binary file encoded in Protocol Buffers format.You can also add a file in Protocol Buffers format via the  
 | 
| Adds a call to a Web service. You can also add a Web service call via the  
 | 
| Adds a Web service call to the Shopify API or to a generic GraphQL API. You can also use the  
 | 
| Simple-Input components can be used as input parameters that are relevant to the entire mapping or only in the context of user-defined functions. For more information, see Simple Input and Parameters in UDFs. You can also insert a Simple-Input component using the  
 | 
| Simple-Output components can be used as output components in mappings and as output parameters of user-defined functions. For more information, see Simple Output and Parameters in UDFs. You can also insert a Simple-Output component using the  
 | 
| Inserts a constant which supplies fixed data to an input connector. You can select the following types of data: String, Number and All other. You can also insert a constant using the  
 | 
| Inserts a variable, which is equivalent to a regular (non-inline) user-defined function. A variable is a special type of components used to store an intermediate mapping result for further processing. You can also add a variable using the  
 | 
| The Join component allows you to join data in SQL and non-SQL modes. You can also add a Join component using the  
 | 
| Inserts a component which allows you to sort nodes (see Sort Nodes/Rows). You can also add a Sort component using the  
 | 
| Inserts a Filter component that can filter data from any other component structure supported by MapForce, including databases. For more information, see Filters and Conditions. You can also add a filter using the  
 | 
| Inserts a component which allows you to filter database data conditionally. For more information, see SQL/NoSQL-WHERE/ORDER Component. You can also access the SQL/NoSQL-WHERE/ORDER component via the  
 | 
| 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 (e.g., month numbers to month names). For more information, see Value-Maps. You can also insert a Value-Map using the  
 | 
| Inserts a Decision Table. This component type enables you to define a set of rules that evaluate one or more input conditions and provide the corresponding output value(s). You can also insert this component via the  
 | 
| Inserts an If-Else Condition that is suitable for scenarios where you need to process a simple value conditionally. For more information, see Filters and Conditions. You can also add an If-Else Condition using the  
 | 
| The exception component allows you to interrupt a mapping process when a specific condition is met. You can also add an Exception component using the  
 | 
| This menu command allows you to insert sticky-note-style comments as free-standing components. For details, see Comments. You can also add a comment by clicking the  
 | 

 toolbar command. For more information, see
 toolbar command. For more information, see  toolbar command.
 toolbar command. toolbar command.
 toolbar command. toolbar command. See
 toolbar command. See  toolbar command. MapForce Enterprise Edition also allows you to process text files with FlexText.
 toolbar command. MapForce Enterprise Edition also allows you to process text files with FlexText.  toolbar command.
 toolbar command. toolbar command. See
 toolbar command. See  toolbar command. For details, see
 toolbar command. For details, see  toolbar command. For more information, see
 toolbar command. For more information, see  toolbar button. See
 toolbar button. See  toolbar button. For more information, see
 toolbar button. For more information, see  toolbar command.
 toolbar command. toolbar command.
 toolbar command. toolbar command.
 toolbar command. toolbar command.
 toolbar command. toolbar command. For details, see
 toolbar command. For details, see  toolbar command.
 toolbar command. toolbar command.
 toolbar command. toolbar command.
 toolbar command. toolbar command.
 toolbar command. toolbar command. For more information, see
 toolbar command. For more information, see  toolbar command.
 toolbar command. toolbar command. In MapForce Enterprise Edition, this component also allows you to define Fault messages in WSDL mapping projects. For details, see
 toolbar command. In MapForce Enterprise Edition, this component also allows you to define Fault messages in WSDL mapping projects. For details, see  toolbar command.
 toolbar command.