Unable to use Document Property in Filter Transformation

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.