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.