...
- Data types that you see in the Transformer page represent types that are understood by the product.
You can change a column's data type in one of the following ways. For more information on the available data types, see Supported Data Types.
A Note about Datetime Data Type
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.
...
Change Type from Column Menus
You can change the data type for individual columns through the following column menus:
...
| Tip |
|---|
Tip: Both of the above methods become individual steps in your recipe. |
Change
...
Type for Multiple Columns
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 LastName, FirstName, and Address to String data type.
| D trans | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
A Note about Datetime Data Type
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.
