Product: TIBCO Spotfire Analyst
Versions:
Summary:
Trying to use a Document Property in a Filter Row Transformation, Spotfire says that the expression is not valid
Details:
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
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.