While transforming your data, you may need to change the data type of one or more columns. For example, data of String type may be the easiest to manipulate. Since there are no mismatched values for String data type, you may wish to change a column's data type to this baseline type.
You can change a column's data type in one of the following ways:
You can change the data type for individual columns through the following column menus:
To the left of the column name, you can click the icon and select a new data type from the list.
Column Data Type Menu
To the right of the column name, you can click the caret to open the column menu. Select Change Type and make a selection from the sub-menu.
Tip: Both of the above methods become individual steps in your recipe.
If you must change the data type for multiple columns to a single data type, you can use a transformation like the following, which changes the columns
Address to String data type.
NOTE: When specifying a data type by name, you must use the internal value for the data type. The value in the column menu is the display name for the type.
For more information, see Valid Data Type Strings.
If you are changing a column's data type to Datetime, you must also select a format string to apply to the column. In the column menus, the available options can be selected after you select Datetime.
For more information, see Datetime Data Type.