Standardize Field

The Standardize Field transformation applies one or more standard conversions to semantically typed fields.

Step name
Defines the name for a step. Provide a meaningful name so that anyone who edits transformation steps in a pipeline will be able to identify the purpose of a step.
Column
Specifies a column to transform. Click to view the list of column names. Column names listed here correspond to the column names in the dataset inspection table. Click in the drop-down list to select a column name. Alternatively, click a column heading in the inspection table to select the corresponding column name in this box. You can use the search box to filter and select columns in the list.
You can only choose from columns that contain rules for the semantic type.
Symantic Type
Shows the symantic type for the selected column. The semantic type determines what types of standardization rules may be applied to data in a column. The semantic type is set for columns in settings for a sample dataset.
Standardize rule
The standardization rules available for a column depends on the semantic type. Supported conversions are detailed in the table.
Semantic type Standardize rules Description
Country ISO2 to Country Converts ISO2 codes to the corresponding country names.
Country to ISO2 Converts country names to the corresponding ISO2 codes.
ISO3 to Country Converts ISO3 codes to the corresponding country name.
Country to ISO3 Converts country names to the corresponding ISO3 codes.
FirstName NickName Transforms nicknames to the longer proper name. For example, "Bill" to "William", "Trudy" to "Gertrude", "Sue" to "Susan", or "Dick" to "Richard".
Tip: There are no conversions between ISO codes (ISO2 to ISO3 or ISO3 to ISO2). To convert between the ISO2 and ISO3 codes, you need to first convert from one ISO code to the country name, then convert the country code to the other ISO code. For example, to convert from ISO2 to ISO3, convert first from ISO2 to Country, then convert the result from Country to ISO3.
Save
Click this button to close settings and save changes to the transformation settings.
Preview
Click this button to preview the results of the transformation settings.
Cancel
Click this button to close settings for this transformations without saving any changes.