Right-click in the data panel to bring up the pop-up menu. You will have access to different options depending on where in the data panel you click.
Data Tables
Option |
Description |
Rename... |
Allows you to change the name of the selected data table. |
Set as Default Data Table |
Sets the selected data table to be the default data table in the analysis. |
Data
Table Properties |
Opens the Data Table Properties dialog where you can edit the properties of the data tables in the analysis. Here, you can add regular relations between the data tables in Spotfire, internal as well as external, which allow you to use details visualizations and propagate marking and filtering between the data tables. |
Columns
Option |
Description |
Rename... |
Allows you to change the name of the selected column. Note: The columns use the same name as their corresponding filters, so renaming a column will also change the filter name, if a filter exists for the column. |
Delete |
[Only available for in-memory data tables.] Deletes the selected columns from the data table. |
Create Filter |
[Only available for columns which currently do not have a corresponding filter.] Creates filters for the selected columns. Note: When working with cube data it is not possible to create filters for measures or sets, only for dimension columns. |
Sort |
|
Categorized |
Groups the columns into different categories, Numbers, Time or Categories, which may help you setting up your visualizations properly. |
No Sorting |
Applies the sorting from the original database to the columns in the list. |
Ascending |
Applies an alphabetical sorting of the columns in the list. |
Descending |
Applies a reversed alphabetical sorting of the columns in the list. |
Column Properties |
Opens the Column Properties dialog where you can edit the properties of the columns in the analysis. |
Geocoding |
Allows you to find a geocoding hierarchy in the library and manually specify that a column should be used for geocoding at a certain hierarchy level. For example, if a column contains state names you can use this menu to specify that this column actually contains US states. Use the tooltip to see some example data of a certain type of encoding to find the correct match. This information can then be used to place data at its correct location in a map chart. When a selection is done in the menu, the column properties specifying the GeocodingType, GeocodingRepresentation and GeocodingHierarchyName are automatically set. If you know that a column contains Longitude or X-coordinates, then select the Longitude / X option, etc. You can also click on Auto-match to make Spotfire attempt to match the content of the column to an existing geocoding hierarchy in the library. |
See also: