Details on New/Edit Relation


Structural relations are used to combine different tables from a data source into a single view in Spotfire, which in turn can be used to create a data table.

  1. Select Tools > Manage Data Connections.

  2. Click on the connection of interest and click Edit.

  3. On the General tab, click Edit... .

  4. Under Relations, click New....

  1. Select Edit > Data Connection Properties.

  2. In the list of Connections, click to select the connection of interest.

  3. Click on Settings....

  4. On the General tab, click Edit....

  5. Response: The  Views in Connection dialog is displayed.

  6. Under Relations, click New....

  7. Comment: You can only edit data tables for data connections that are embedded in the current analysis by using these steps. For shared library connections it is recommended to use the Manage Data Connections tool as described above instead.

  1. Open the Views in Connection dialog. See above.

  2. In the Available tables in database list, locate the table with the relation you want to edit, and select it in the list.

  3. Response: The Edit... button is enabled.

  4. Click Edit....

data_new_edit_relation.png

Option

Description

Foreign key table

Lists all tables currently available. Select one of the tables for which you wish to define a relation.

Column

Lists all columns available in the foreign key table. Select the column to be used in the matching of rows.

Primary key table

Lists all tables currently available. Select the table you wish to relate to the previously selected foreign key table.

Column

Lists all columns available in the primary key table. Select the column to be used in the matching of rows.

Second column pair

Select this check box if you want to use a second pair of columns to match the tables.

Third column pair

Select this check box if you want to use a third pair of columns to match the tables.

See also:

Details on Data Tables in Connection