Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0710

D toc

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. 

  • Data types that you see in the Transformer page represent types that are understood by the product. 


Tip: You can use the Change Column Type transformation to override the data type inferred for a column. However, if a new transformation step is added, the column data type is re-inferred, which may override your specific typing. You should consider applying Change Column Type transformations as late as possible in your recipes.

For more information on the available data types, see Supported Data Types.

Change Type

You can change a column's data type in one of the following ways:

Change from Column Menus

You can change the data type for individual columns through the following column menus:

  1. To the left of the column name, you can click the icon and select a new data type from the list. 

    D caption
    Column Data Type Menu

  2. 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.

Change Data 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 LastNameFirstName, and Address to String data type.

D trans
p01NameColumn 1
p02NameColumn 2
p03NameColumn 3
p04NameNew Type
SearchTermChange column 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.

Change 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.

Via column menus

You can apply a Datetime data type through the column menus. When you choose the Datetime data type, you must apply a format for your Datetime values. For more information, see Choose Datetime Format Dialog.

Via Transform Builder

In the Transformer Builder, you can apply a specific transformation to format one or more columns to Datetime data type, using a specific format.


Tip: You can use the following transformation to change the format of a Datetime column.

This transformation looks like the following:

D trans
WrangleTextsettype col: myDate datetimeType: 'Datetime','mm-dd-yy hh:mm:ss','month*dd*yyyy*hh:MMaX' type: Datetime
p02NameColumn 1
p03NameNew Type
p04NameDate/time Type
SearchTermChange column type

For more information, see Datetime Data Type.