The Change Data Types transformation is used to change the data types of one or more of the columns in a data table.

See Transforming data for information about how to add a transformation to an analysis.

Option	Description
Available columns	Shows all available columns. If the data type has been changed for a column, the new data type will be shown under New Data Type in the list. If not, that field will be empty for the column. You can narrow down the list of available columns by typing a part of a name in search field. You can also enter an expression in the field, using the rules described on Searching in Spotfire clients. Press Ctrl or Shift to select multiple columns.
New data type	Allows you to choose a new data type for the selected column.
Sample value	Shows one sample value from the chosen column with the new data type applied.
Formatting	Opens the Formatting dialog, where you can change the formatting of the calculated column.
Reset All	Resets the data types of all columns.
Preview	Shows a preview of what the data will look like after the completion of this transformation.