Details on Data Table Properties – Properties


On the Properties tab it is possible to specify custom data table properties which are applicable throughout the document. The data table properties can be used inside expressions using Insert Column from Expression or Custom Expressions.

  1. Select Edit > Data Table Properties.

  2. Click on the Properties tab.

data_table_properties_properties_d.png

Option

Description

Data tables

Lists the data tables available within the document. The names of the data tables in this list are the names that will be shown in the data table selectors, in the legends of visualizations, etc.

You cannot have two data tables with identical names in the same analysis.

Rename...

Allows you to change the display name of the selected data table.

Refresh Data

Reloads the data from the source. This is a way to refresh the data while analyzing, without having to reload the entire file. See Embedded or Linked Data? for information about what a refresh does with embedded data.

You can select to refresh data With Prompt which allows you to edit transformations or import settings before the refresh or Without Prompt which uses the latest settings.

Tip: If you want to reload multiple data tables simultaneously, you can instead select File > Reload Data on the main menu.

Note: If a data table is loaded on demand or calculated using a data function you need to click OK in the Data Table Properties dialog to actually start the data refresh.

Delete

Removes the selected data table from the analysis. Any visualizations that use the deleted data table will become invalid.

Set as Default

Sets the selected data table to be the default data table. This means that the selected data table will be used when new visualizations are created.

You can always change the data table to use in a specific visualization from the Data page in Visualization Properties or from the Data table selector in the legend.

Available properties

Lists all properties currently available for the selected data table. For example, there are a number of properties related to geocoding which can be set for geocoding data tables.

When data tables have been added using information links, the Keywords and Description defined in Information Designer will also be displayed.

If you have defined custom properties for the data table, then these properties are also listed here.

New...

Opens a dialog where you can add new data table properties to the document.

Edit...

Opens a dialog where you can edit the selected data table property.

Delete

Deletes the selected property.

See also:

How to Edit Data Table Properties

Details on Data Table Properties - General

Details on Data Table Properties - Source Information

Details on Data Table Properties - Relations

Data Table Properties – Column Matches

Data Table Properties – Scheduled Updates

Data Tables Overview