Context menu (source structure)
Option |
Description |
Create new |
New fields, nodes and database nodes can be created here. If you create a new database node, you can select the alias of a connected database and a table from that database. The structure of the database table will then be represented in the source structure node. See also section Phase 4 - SQL Execution. The option Create field in new node creates a top node for a selected field. |
Define matchcodes Pass matchcodes upwards Delete matchcodes |
Match codes can be defined here. If a node (or a field) has match codes and is located in one or more parent nodes, those match codes can automatically be entered in all parent nodes. Deletes the matchcodes. |
Field overview |
The field overview provides a simple overview of, for example, the data types and lengths, etc. of all fields of a node. Note: Can be exported as a CSV file. |
Find first link Remove link |
Finds the first field in the target structure (there can be more than one) onto which this field is mapped. You can also delete all mappings of this source structure field. See also section Search and find. |
Copy and map into destination tree |
The node marked in the source structure is completely transferred to the target structure. All its fields of the same name are mapped and paths are set to all nodes of the same name. |
Aggregate functions |
See section Special nodes for aggregate maps in source structure. |
Cut/Copy/Paste/Delete |
Refers to the entire structure or selected fields/nodes. |
Open/Close direct sub nodes |
Sub-nodes of the selected node are opened or closed. |