As an analyst I want to use categorical expressions based on a secondary data table in my visualization. Using a column from a secondary data table in the Line By or Color By axis when the x and y axis are based on the primary data table yields this explanation of why this is not allowed:
* "Categorical expressions can only reference columns in the main data table"
*Details:*
The only way to do this currently is to "Insert > Columns" from secondary table to the primary data table so that they can be used in the visualization. This works but requires a duplication of data in the analysis which is not efficient when large amounts of data are in play.
In Spotfire 10.9 and later the Display values feature may be used to solve this issue if the data is suitable. For example an ID in the main data table may be used to group the data, while a more human friendly label in a secondary data table is displayed in the visualization.