Details on Column Properties – General

Metadata about the columns and hierarchies is handled in the Column Properties dialog. Here, it is possible to view information about the origin of columns, descriptions on columns, min and max values within a column, etc. See Column Properties Descriptions for more information about the default properties. All columns in the data view have the same set of column properties, but a property may have undefined values for some columns.

To reach the Column Properties dialog:

Select Edit > Column Properties.
Click on the General tab.

Top part of dialog

Option	Description
Data table	Only available when more than one data table is available in the analysis. Specifies the data table that you are currently viewing column properties for.
Columns and hierarchies	Lists all columns and hierarchies available in the data table. 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.
Insert
Calculated Column	Opens the Insert Calculated Column dialog, where you can create a new column from an expression.
Binned Column	Opens the Insert Binned Column dialog, where you can group the values of a column into a smaller number of bins (groups).
Hierarchy	Opens the Insert Hierarchy dialog, where you can create a hierarchy (an ordered structure) by combining columns with each other.
Delete	Removes the selected column or hierarchy from the data table.

General tab

Option	Description
Name	The name of the column or hierarchy used in the application.
Description	An optional description of the column.
Data type	The data type of the column.
Column Information	Displays additional information about the column or hierarchy, such as how it was created.
Edit...	Available for calculated columns, binned columns or hierarchies only. Opens the dialog where the column was created, so that the expression can be modified.
Freeze Column	Locks the column so that it cannot be edited anymore, and any replace data operations will not attempt to recalculate this column. It is possible to freeze columns of types Calculated, Binned, Result, Tags and Mask (Filter To/Out). Regular imported columns cannot be frozen, and neither can hierarchies. Freezing may be desired when you want to save the result from a calculation to prevent it from being overwritten or for performance reasons. You may also want to freeze a column in order to be able to use it in a join condition when adding columns to the data table. Freezing a column will force the data table to be embedded. This restriction on the data table will remain even if you remove the frozen columns from the data table at a later stage. Note: It is not possible to unlock a previously frozen column.