Product: TIBCO Spotfire®
While doing an Insert Column and Matching the columns, calculated columns are not listed in the "From Current Table" field.
Calculated columns are not listed in the "From Current Table" field, while doing Insert Column - Match Columns. See attached (Filename: Issue.PNG image). I.E., when trying to insert a column from one data table (T1) into another existing table (T2), and you want to match a column from T1 (e.g., City) to a calculated column from T2 (i.e., City_Name), the calculated column is not listed in the dialog's "From Current Table" field.
Below are Workarounds:
(A) Instead of creating the new column with "Insert > Calculated Column", create it using "Insert > Transformations > Calculate New Column using expression". Using this method, you will be able to insert the column.
or
(B) Load the desired analysis file into the Spotfire Analyst (client). Then select "Edit > Column Properties" from the main menu. Select the calculated column you want to use in matching, then Freeze the column. See attached (Filename: freezecolumn.PNG image). Then create the new column using "Insert > Column".
NOTE: It is not possible to unlock a previously frozen column. Freezing a column will force embed the data table. This restriction on the data table will remain even if you remove the frozen columns from the data table at a later stage. You can never change the data table back to linked table.