In Spotfire, the filter panel allows one to easily remove ranges of values from your data. We can gain even further granularity and control of what we hide from a dataset by applying the “Limit data using expression” window. However, the “Limit data using expression window” doesn’t play nice when you want to replace a data table by matching columns with different names.
When we use replace data functionality and the limiting expression uses a matched column, the expression doesn’t update the column name (as it does with other expressions), which leads to unexpected results. Call this one of those “endearing” Spotfire intricacies.
Fortunately, we can get around this issue by creating a Show/Hide calculated column and rerouting our limiting expression through a calculate column, which will update when you replace data.