Error when using custom expressions editor with multiple tables in a visualization

Error when using custom expressions editor with multiple tables in a visualization

book

Article ID: KB0077291

calendar_today

Updated On:

Products Versions
Spotfire Analyst 10.3.1 HF-003 and lower

Description

If your .dxp file has two related data tables, and those tables have columns which have the same name, but different case (upper vs lower), then when trying to use these two columns in a custom expression, the custom expression tab may fail to recognize the correct table resulting in errors in the expression when the expression editor is closed. For example, the column name may have some or all characters in upper case in one table like "MyColumn", and a differing case in the second table like "mycolumn".
User-added image

Issue/Introduction

Error when using custom expressions editor with multiple tables in a visualization

Resolution

This is caused by a defect which has been fixed in hotfix TS_10.3.1.13 LTS HF-004, 10.3.2, and in versions 10.4 and higher.

To resolve, please download and apply client hotfix 10.3.1 HF-004, or upgrade to versions 10.3.2 or 10.4 or higher.

Additional Information

Doc: Details on Custom Expression Wiki: List of hotfixes for TIBCO Spotfire® Clients (Analyst, Web Player (Consumer/Business Author) and Automation Services) > TS-60299 - Expressions referencing secondary tables sometime got wrong casing after closing the custom expressions editor