Data Tables Associations with Primary - Foreign Keys

Thank you Ahmed.
Have you tried to set the display value for the Add_id column to the city_name from the Address tables? This is have from the data in analysis flyout. See screenshot

Hi @Arnaud,

Take this scenario. I have two data tables in one Spotfire Application.

Table 1 Customers

C_id | C_name | Add_id

Table 2 Address

Add_id | city_name

• Relation created Address.Add_id = Customer.Add_id in the Data > Data Tables Properties

• We don't want to join the two tables. The Customer table very long and Address table very wide.

• I want to build a bar chart (or other aggregated visualisation) to show city_name on X axis and number of customers in Y axis.

• Currently we cannot achieve this even though the 2 tables associated with primary / foreign key add_id.

compared with other BI tools this is very easy can be achieved. Can you advise how this can be created in Spotfire without joining / merging the two tables?

Ahmed

Hello Ahmed. Thank you for submitting this idea.

When adding multiple tables from a relational database, Spotfire creates the data tables associations based on the database foreign keys. And there is also the data table relations that you can create manually between data tables (Data > Data Table Properties).

Is your request about being able to select multiple related tables and have Spotfire create the relations between them while keeping them separate, without importing columns from one to another?