Upper Case
The Upper Case processor converts text attribute values to upper case, and returns the converted value in a new attribute.
Use the Upper Case processor where you want to use validation rules that are not case sensitive, or for case standardization as part of data cleansing.
The following table describes the configuration options:
Configuration | Description |
---|---|
Inputs |
Specify any String or String Array type attributes that you want to convert to upper case. Number and Date attributes are not valid inputs. Note that if you input an Array attribute, the transformation will apply to all array elements, and an Array attribute will be output. |
Options |
None. |
Outputs |
Describes any data attribute or flag attribute outputs. |
Data Attributes |
The following data attributes are output:
|
Flags |
None. |
The Upper Case transformer presents no summary statistics on its processing.
In the Data view, each input attribute is shown with its new derived attribute with numbers stripped to the right.
Output Filters
None.
Example
In this example, Upper Case is used at the beginning of a process to convert all String attributes to upper case for further processing:
TITLE | TITLE.Upper | NAME | NAME.Upper |
---|---|---|---|
Ms |
MS |
Lynda BAINBRIDGE |
LYNDA BAINBRIDGE |
Null |
Null |
William BENDALL |
WILLIAM BENDALL |
Ms |
MS |
Karen SMITH |
KAREN SMITH |
Miss |
MISS |
Patricia VINER |
PATRICIA VINER |
Mr |
MR |
Colin WILLIAMS |
COLIN WILLIAMS |
Mr |
MR |
Ian PATNICK |
IAN PATNICK |
Ms |
MS |
Robera REYNOLDS |
ROBERTA REYNOLDS |
Miss |
MISS |
Winifride ROTHER |
WINIFRIDE ROTHER |