Jump to content
We've recently updated our Privacy Statement, available here. ×

Is it possible to detail table in Spotfire which include columns from two data


Alexander Bogachov

Recommended Posts

Good afternoon! I have two data tables those have similar columns and different values. I create right mathes and relations between them. I create crosstable with 2 columns from two tables. Then I create another crosstable, and set the marking. When I click on row on the second table, the value is changing only for one column of th first table. How could I detalize the second column
Link to comment
Share on other sites

  • 1 month later...

That behavior is as per design. When fetching from secondary data table in visualization, it is only based on column matches seen in Data section

 

In your case, column match would only be on subindicator column as it is used in visualization. Now you are limiting data based on Company column which is not present in cross table so Value2 records corresponding to X or Y company value would not be fetched.

To resolve this issue, you can use any of the two approaches:

1) Insert Value 2 column in table 1 from table 2 as all rest of the columns are already matching.

https://docs.tibco.com/pub/sfire-analyst/10.3.0/doc/html/en-US/TIB_sfire...

2) Use Company column in details crosstable as well so column match on company column gets considered. If you want to hide that company column, you can do that with small iron python script like below:

from Spotfire.Dxp.Application.Visuals import CrossTablePlot

vis.As[CrossTablePlot]().RowHeaderWidths.Item[0]=0where vis is a script parameter referencing details cross table visualization.

Above iron python script hides company column by making its width 0. From UI, you will only be able to set mininum width as 30. Keep Company column in first position from left.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...