Attributes for Nodes (target structure)


images/download/thumbnails/44946665/arrow_up-version-1-modificationdate-1583802678582-api-v2.png Introduction: You can find a description of this phase in section Phase 3 (Introduction).


images/download/thumbnails/44946665/image2020-3-18_18-28-21-version-1-modificationdate-1584509300784-api-v2.png

Attribute

Description

Name

Description

Name of the node and optional description. See also section Naming Conventions for Nodes and Fields.

XML/JSON handling

See sections XMLNoTemplateUnit, create xml from node(a, b, c, d, e, f, g), JsonCreationUnit and ExtendedJsonCreationUnit.

Minimum

Maximum

Checks the minimum and maximum occurrence of a node. See also section Icons in Mappings.

Inactive

An inactive node is not entered/generated when the target tree is generated. See also sections Mapping - Filling a Record of the Target Tree and Icons in Mappings.

Only for SQL

If this option is set, the node will not be displayed in the output data. Nodes of this type are only for the interaction with databases. See also section Icons in Mappings.

Iteration node

Indicates whether a node will be included in the output data or if it is only traversed for calculation purposes. See also sections Iteration Nodes and Calculation Fields and Icons in Mappings.

Path

You can either drag a source structure node onto this target structure node. In that case, the name of the source structure node is automatically entered in this attribute field. Or you search for the source structure node in a list using the folder icon. Alternatively, you can enter the name manually. In addition, you can also use the blue folder icon to select a source structure node or an Integer variable. Note: See also sections Records and Paths, Path Types and Icons in Mappings.

Is relative path

See also attribute Path and section Repetitions of Target Structure Nodes by Source Structure.

Iteration

See section Processing Order of Nodes.

Optional settings

See sections MultipleFileCreatorUnit and X12CreationUnit.

XML namespace

This property allows an XML namespace to be assigned to the XML element generated from the field. See also sections XMLMemSaveTemplateParserUnit and XMLNoTemplateUnit.

Line break

See section New Line for CSV/Fixed Length.

Sort field

Sorting

See section Sorting in Nodes.

Optional XPath filter

Only relevant for the XML parser V4.

Advanced Settings


You can access the advanced settings via checkbox All.


Attribute

Description

Transaction control

Database alias

SQL table/procedure

Empty table

Optional pre-SQL execution

SQL mode

See section Phase 4 - SQL Execution.

Optimize path

If this attribute has the value No, the usually active path optimisation will be deactivated. If a child node in the target structure has the same path as its parent node and its attribute Is relative path has the value No, this node will only appear once in the target tree if the optimisation is enabled. If the optimisation is disabled, the node appears in the target structure as often as it appears in the source structure.

Row offset variable

The value of the Integer variable specified in this field determines how large the offset for the nodes to be output in the target tree is. An offset of 2, for example, means that only the second node (and the following) will appear in the target tree. This attribute only works if the attribute Optimize path has the value No.

Step size variable

The value of the Integer variable specified in this field determines how large the step size for the nodes to be output in the target tree is. With an offset of 2 and a step size of 2, the nodes 2, 4, 6, etc. are output in the target tree.