The material provided is for informational purposes only, and should not be relied on in making any purchasing or investment decision. The information is not a commitment, promise or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at our sole discretion. © 2026 Cloud Software Group, Inc. All rights reserved
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?