something amazing when Manage Relationships

[Kwok Holy]

Hi,

The left data table and right data table exchange automatically when I clicked OK for adding a new relationship between two tables.

like this :

left->Table1 : String(WellID) right->Table2 : String(WellID)

BUT, after clicked OK, actually it was left->Table2 right->Table1

PS:my Table2 has a column `ID` like `ID` `WellID` Table1 only has `WellID`

So, emmmmmwhat's wrong with it

THANKS!

[Gaia Paolini]

This looks like a very specific issue with your dataset/dxp. Are you able to upload an example that shows the problem

[Kwok Holy]

Hi Gaia,

 

  Thanks for paying attention to my question!

 

  As what I said above, there are two tables, one is Table1, another is Table2. And then, the Table1 has a column called WellID,  the Table2 has WellID and ID

 

  Like this :(The file type of Both tables is Excel)

 

Table1

 

WellID	Other Columns
data...	data...
data...	data...

 

 

 

Table2:

 

ID	WellID	Others
data..	data..	data..
data..	data..	data..

 

 

 

My operation:

 

Data -> Data Table Properties -> Relations -> Manage Relations -> New... 

 

window______________________________________________________

 

Left Data Table : Table1              Right Data Table: Table2

 

Left Column: WellID                    Right Column: WellID

 

....

 

                                                                       OK

 

_________________________________________________

 

After I clicked `OK`, the Manage Relations Window showed Left Data Table was Table2, Right was Table1. 

 

Totally exchanged!

 

Do you know how to solve this problem

 

Sincerely, hope your reply

 

THANKS

 

 

[Gaia Paolini]

I followed your instructions and it did not happen to me. I related WellID from data1 to WellID of data2.

Maybe related to your data types or your data source or your version of Spotfire.

I think it probably is best if you open a support case