Change Data Types can be used as a transformation step when adding or replacing data tables. Tip: You can replace a data table with a transformed version of itself.
To reach the Change Data Types dialog:
Select File
> Add Data Tables... or File > Add
On-Demand Data Table... and add the data of interest.
If you already have an analysis open, you can also choose:
File > Replace Data Table...
Insert > Columns...
or Insert > Rows...
Click Show transformations.
Select Change data types from the drop-down list and click Add.....
Option |
Description |
Available
columns |
Shows all available columns. If the data type has been changed for a column, the new data type will appear under "New Data Type". If not, that field will be empty for that column. You can narrow down the list of available columns by typing a part of a name in the "Type to search" field. You can also enter an expression in the field, using the rules described on the Searching in TIBCO Spotfire page. Press Ctrl or Shift to select multiple columns. |
New
data type |
Allows you to choose which data type you want a selected column to have. |
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 column with the new data type. |
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. |
See also: