Transformations

Back Next

Normalized fields

Define the fields to be normalized on the

Normalized Fields

tab. You can also include other incoming fields that you want to use in the mapping.

When you define normalized fields, you can create fields manually or select fields from a list of incoming fields. You can also create field groups when the source data contains multiple-occuring groups of fields. Group-level fields can contain fields and other groups.

The following table describes the properties that you configure for normalized fields:

Property	Description
Name	Field or group name. In advanced mode or SQL ELT mode, this property is always the field name.
Level	Field or group level. In advanced mode or SQL ELT mode, the value is always 1.
Occurs	Number of instances of the field or group in the source row.
Type	The field datatype. The datatype can be either String or Number. Doesn't apply to group-level fields.
Precision	Total number of digits in a number. For example, the number 123.45 has a precision of 5.The precision must be greater than or equal to 1. Doesn't apply to group-level fields.
Scale	Number of digits to the right of the decimal point of a number. For example, the number 123.45 has a scale of 2. Scale must be greater than or equal to 0. The scale of a number must be less than its precision. The scale may cause zero-filling or truncation with rounding. For example, a scale of 5 causes 123.45 to be expressed as "123.45000" while 123.456789 becomes "123.45679". Doesn't apply to group-level fields.

When incoming fields include multiple-occurring fields without a corresponding category field, you can create a field to define the occurs for the data. For example, to represent three fields with different types of income, you can create an Income field and set the occurs value to 3.

Normalizer transformation

Occurs configuration

Field groups

Unmatched groups of multiple-occurring fields

Generated keys

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal