DataFlux Data Management Studio 2.5: User Guide
You can add a node to a data job to make all alphabetical values in a field uppercase, lowercase, or proper case. (Proper case means treating a field value as a proper name by capitalizing the first letter of each word, with the remaining characters in lowercase.) Once you have added the node, you can double-click it to open its properties dialog. The properties dialog includes the following elements:
Name - Specifies a name for the node.
Notes - Enables you to open the Notes dialog. You use the dialog to enter optional details or any other relevant information for the input.
Locale - Specifies the locale within your Quality Knowledge Base (QKB) used to change case.
The Casing fields section of the dialog includes the following elements:
Available - Displays the fields that you can make available for the next step in your data job. Items displayed in this list are dependent on your data sources and any preceding steps in your data job.
Selected - Displays the fields that will be made available to the next node in your data job. Use the drop-down menu in the Type column to select from the following cases: Upper, Lower, and Proper. You can select a previously defined case definition with the drop-down menu in the Definition column.
Additional Outputs -Displays the Additional Outputs dialog. This dialog enables you to specify the fields that you can make available to the next node in your data job.
Preserve null values - When selected, specifies that null values in the data source are preserved.
You can access the following advanced properties by right-clicking the Change Case node:
|
Documentation Feedback: yourturn@sas.com
|
Doc ID: dfU_PFQual_ChngCase.html |