In this example, we have a customer’s data in which we want to convert the CustomerID information into lower case. Map the CustomerID to the str data field under the Input node inside the function transformation object.
Right-click on the header of function transformation object and select Preview Output. You can see that all the CustomerIDs have been converted into lower case.
Name
ToLower
Applicable To (DataType)
String
Purpose
To convert the string argument into lowercase characters.
Description
Converts the string argument into lowercase characters.
Return Type
String
Syntax
str [System.String] – string which will be converted.
