Attributes for Nodes (target structure)
Introduction: You can find a description of this phase in section Phase 3 (Introduction).
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. |