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 calculated columns or custom expressions.
To reach the Data Table Properties dialog:
On the menu bar, select Data > Data table properties.
Click on the Properties tab.
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. Tip: You can also change the data table name in the Data Canvas. |
Reload
Data |
Reloads the data for the selected data tables from the sources, if sources are available. This is a way to refresh the data for one or more data tables while analyzing, without having to reload the entire file. See Embedded or Linked Data? for more details about reloading. You can select to either reload Linked data only, which reloads all linked data sources with the data loading settings Always new data or New data when possible, or All data which reloads all sources that are possible to reload, including Stored data and Embedded data (when applicable). 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 reload. |
Delete |
Removes the selected data tables from the analysis. Any visualizations that use a deleted data table will become invalid. You cannot delete all data tables; see Replacing a Data Table or Replacing a Data Source instead. |
Set
as Default |
Sets the selected data table to be the default data table. The default data table is used when new visualizations are created, unless you have just interacted with the Data in analysis flyout, in which case the data table selected in the Data in analysis flyout is used. 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
Data Table Properties - General
Data Table Properties - Source Information
Data Table Properties - Relations
Data Table Properties – Column Matches