While doing an Insert Column and Matching the columns, calculated columns are not listed in the "From Current Table" field in Spotfire

While doing an Insert Column and Matching the columns, calculated columns are not listed in the "From Current Table" field in Spotfire

book

Article ID: KB0070115

calendar_today

Updated On:

Products Versions
Spotfire Analyst All Versions

Description

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.
 

Resolution

Below are Workarounds:

(A) Instead of creating the new calculated 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. 

Note: For the latest Spotfire versions, please refer to "How to Add Columns" in Spotfire Analyst User Guide (https://docs.tibco.com/pub/sfire-analyst/latest/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=add%2Fadd_how_to_add_columns.htm) for information on how to add calculated columns using transformations. As stated there: "
Tip: If you cannot match your desired columns directly, a transformation added on the node of the original data set might be used to create a calculated column to use in the match." 

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.

Issue/Introduction

While doing an Insert Column and Matching the columns, calculated columns are not listed in the "From Current Table" field in Spotfire.

Additional Information

Attachments

While doing an Insert Column and Matching the columns, calculated columns are not listed in the "From Current Table" field in Spotfire get_app
While doing an Insert Column and Matching the columns, calculated columns are not listed in the "From Current Table" field in Spotfire get_app
While doing an Insert Column and Matching the columns, calculated columns are not listed in the "From Current Table" field in Spotfire get_app
While doing an Insert Column and Matching the columns, calculated columns are not listed in the "From Current Table" field in Spotfire get_app