The Standardizer transformation is a passive transformation that examines input strings and creates standardized versions of those strings.
The Standardizer transformation creates columns that contain standardized versions of input strings. The transformation can replace or remove strings in the input data when creating these columns.
For example, you can use the Standardizer transformation to examine a column of address data that contains the strings
Street
,
St.
, and
STR
. You can replace all instances of these strings with the string
St
.
Within a Standardizer transformation, you can create multiple standardization strategies. Each strategy can contain multiple standardization operations. The Standardizer transformation provides a wizard that you use to create strategies.