Advanced Normalization Data Translation (NDT)
The Advanced Normalization Data Translation utility allows you to create, update, and manage category/driver translations, conversions, and splits for normalization data. This utility helps standardize data by mapping source codes to normalized codes and applying conversion factors or splits as needed.
To use the utility, navigate to Utilities > Configuration Utilities > Advanced NDT
You can also use the Data Import Utility to import by tab-separated text file.
Utility Fields
The following fields are available when creating or editing a translation:
Field | Description |
|---|---|
Description | Description to help identify the purpose of this translation. |
Category Name | Select the category for which you want to create or modify translations. |
Normalized Code | The standardized code that the Agent Code will be translated to. |
Agent Code | The source code from your data that needs to be translated. |
Conversion Factor | A numeric value that will be multiplied by the source data value during normalization. |
Split | Select checkbox to enable splits. When enabled, additional split fields will appear. |
Split Codes | When Split is enabled, select codes that will receive portions of the source data. |
Split Factors | For each split code, enter the numeric factor that the source data will be manipulated by. |
Actions
The following actions are available in the utility:
Action | Description |
|---|---|
New Value | Creates a new translation entry. |
Edit | Modifies an existing translation entry. 2nd column in table - checkbox. |
Delete | Removes a translation entry. 1st column in table - trash can icon. |
Save | Saves changes to a new or existing translation. Bottom of translation entry/edit modal. |
Translation Types
Simple Translation
A one-to-one mapping where an agent code is translated to a single normalized code, with a conversion factor.
Example:
Agent Code: ABC
Normalized Code: XYZ
Conversion Factor: 1
Split Translation
A one-to-many mapping where an agent code's value is distributed across multiple normalized codes according to specified split factors.
Example:
Agent Code: ABC
Split: Y
Split Code 1: XYZ (Factor: 1)
Split Code 2: DEF (Factor: 2)