How to use one filter to control two tables in TIBCO Spotfire?

How to use one filter to control two tables in TIBCO Spotfire?

book

Article ID: KB0071969

calendar_today

Updated On:

Products Versions
Spotfire Analyst All

Description

If you have two tables with the same column "Name", and this column has same values, you can use only one filter and limit the data in both the tables.

Consider Tables T1 and T2 with the following data set.

T1:
Name     Company    Shares    Quarter
Sherlock   ABC            100            Q1
Holmes     XYZ            108            Q1
Watson     SAMPLE      90             Q1
ROSS       DXP            200            Q1

T2:
Name    Salary    Phone
Sherlock    1000      100
Holmes    2000      121
Watson    2500      180
ROSS      3000      191

By using the "Name" column in table (T1) you can limit the rows in table (T2).

Environment

All

Resolution

Use the following steps to achieve the required result :

1) Establish a relation between tables T1 and T2 by performing the following steps:

For TIBCO Spotfire Analyst versions 10.0.0 and higher:-
  a) Go to Data > Data Table Properties.
  b) In Data Table Properties select the Relations tab and choose the Manage Relations button.
  c) In the Manage Relations window, click the "New" button. The "New Relation" prompt will open. Select the column "Name" for both data table

For TIBCO Spotfire Analyst versions 7.14.0 and lower:
  a) Click on Edit > Data Table Properties.
  b) In Data Table Properties select the Relations tab and choose the Manage Relations button.
  c) In the Manage Relations window, click the "New" button. The "New Relation" prompt will open. Select the column "Name" for both data table T1 and T2 and click "OK" and "Apply".
2) Once the relationship is established between two tables, in the Filters panel at the corner of table name you will find this icon,User-added image.

3) Clicking the icon, the related data table with 3 options are displayed.
4) If you want the "Name" column in table T1 to control the rows in table T2, click the  User-added image icon in Filter panel of table T2. Select the option "Filtering in T1" and choose "Include Filtered Rows Only".

Issue/Introduction

How to use one filter to control two tables?

Additional Information

Doc: Filtering in Related Data Tables