How to relate two tables with column name I selected

[Kyujeong Lee]

Two tables are below.

 

 

 

< Data Table >

 

 

 

 

< Limit Table >

 

 

Date

Data-A

Data-B

Data-C

Data-D

 

Data

Limit

 

 

9/1

90

30

50

10

 

Data-A

90

 

 

9/2

89

33

48

8

 

Data-B

30

 

 

8/3

91

31

48

9

 

Data-C

50

 

 

 

 

 

 

 

 

Data-D

10

 

 

 

I want to like draw chart from

X-Axis is Date and Y-Axis is data from I select Data-A or Data-B.

And I want to add line which is a fixed Y value.

This is problem. If I select Data-A, I want Y-value of line to be Limit value from

 

Please what should I do

[Fabian Duerr]

In our Spotfire version we have an extension that allows to store limits to a data table just like you want it to do. But as far as I know this a a self developed extension. It basically stores the limit from a limit table as a column property in the data table. The matching is done by column name. I think this is a great solution but I don't know how this works in detail.

 

A workaround would be to unpivot your data table and then merge your limit table. Do you know how to do that or do you need further instructions