Attributes for Fields (target structure)


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


images/download/thumbnails/44946676/image2020-3-18_18-28-25-version-1-modificationdate-1584509303904-api-v2.png

Attribute

Description

Name

Description

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

Calculation field

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

Mandatory field

If a field is marked as a mandatory field, an error is generated if the field has an Empty Flag. Whether a mandatory field has been filled can be checked in the mapping test with option Perform min/max checks.

Fix value

You can specify a fixed value for a field. See also section Order of Value Assignments.

Data type

The data type of the field.

Length

For data with the document type Fixed-length, the value specified here defines the length of the field (so when this fields end and the next one starts). For data with the document type CSV, the content of the field is shortened to the length entered here (if the attribute has the value 0, the content will not be shortened at all).

Template

Use template

You can specify a format template. At the moment, the template is only evaluated if the data type is numeric or Date/Timestamp and the field actually has a value. The template is evaluated in the same way as the function format date/timestamp to text(a, template b, [Locale c], [Timezone d]), where b is the template. The template will be applied to the field after the last value assignment and if the attribute Use template has the values Yes.

See also section Format Templates for Dates and Times.

Fill with

The character to be used to fill the field value up to its specified length. If more than one character is specified, only the first one will be used. See also attribute Fill from left.

Fill from left

Specifies whether to fill from the (Yes) or from the right (No). See also attribute Fill with.

XML namespace

This attribute allows an XML namespace to be assigned to the XML element generated from the field. See also the Integration Units XMLMemSaveTemplateParserUnit and XMLNoTemplateUnit.

Name for logging

The string <Field name> (<Name for logging>) Assigned value is '<mapped value>' will additionally appear in the job log if attribute Log field value is set to Yes.

Log field value

If set, the value assigned to the target field will be logged (starting with the string Assigned value is). You can use the advanced search in the Control Center to specifically look for those entries. An application example would be to log order numbers and later look for jobs that processed a certain order. It is then no longer necessary to search in the input data. See also attribute Name for logging.

Optional XPath filter

Only relevant for the XML parser V4.

Advanced Settings


You can access the advanced settings via checkbox All.


Attribute

Description

SQL column name

SQL key

SQL AutoGenKey

Skip empty SQL value

These settings are only relevant for phase 4.