Page tree

Versions Compared

Key

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

...

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


Tip

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.

...

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

Via column menus

You can apply a Datetime data type through the column menus. When you choose the Datetime data type, the available options can be selected after you select Datetime. 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

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

This transformation looks like the following:

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

For more information, see Datetime Data Type.