Best way to update imported columns?

Question

I have a table in spotfire with several columns imported from another table as a search. For example, Col2 is used to import ImportedCol:

+------+------+-------------+ | Col1 | Col2 | ImportedCol | +------+------+-------------+ | 1 | A | Val1 | | 2 | B | Val2 | | 3 | A | Val1 | | 4 | C | Val3 | | 5 | B | Val2 | | 6 | A | Val1 | | 7 | D | Val4 | +------+------+-------------+ 

However, data in Col2 is subject to change. In this case, I need to import ImportedCol, but Spotfire just saves the old imported data. Now I delete the imported column and re-add it to update the link. Is there a way to dynamically import data when loading a document or updating information links?

Answer 1

I found a problem.

It turns out that turning to data in the same table creates a circular link that overrides the embed / link setting in that table. My workaround is to make the rod as its own information link, that is, the table join the original link and the new rod is one.

Answer 2

I found this to happen sometimes, although I'm not quite sure how to explain why. my workaround is to create "virtual" data tables from existing ones.

consider a linked table as A and your embedded table as B start with the default state, that is, before importing any columns.

add a new data table. the source for this table should be "From Current Analysis" and using A we will consider this as C , and it will become your main data table, and C will be updated when any changes to A or B .

to illustrate: