Unable to use Document Property in Filter Transformation
Article ID: KB0072636
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | - |
| TIBCO Cloud Spotfire | - |
Description
When trying to use a Document Property in a Filter Row Transformation, Spotfire gives an error saying that the expression is not valid. For example:
Document Property: colSelect
Expression in Filter Transformation: ${colSelect}<=3
Issue/Introduction
Trying to use a Document Property in a Filter Row Transformation, Spotfire says that the expression is not valid
Resolution
The reason the ${colSelect}<=3 expression doesn't work in the Filter transformation is because the transformations are part of the import process so they don't have access to the preprocessor (the $syntax) functions.
One workaround is to create a column with the expression and use it as a Filter argument. Or create a custom query to limit the data that is being imported into Spotfire.
Feedback
Yes
No
Powered by
