Dynamic searching of columns in calculated column transformation

Hi Supporters,

Please find the attached template to reproduce the issue. And refer to the TIBCO Case Number 01453993

We have the below formula which is valid if you do it via Insert -> Calculated Column. 
But it's not valid if you do it via Insert -> Transformations -> Calculate new column. A warning message “Preprocessor syntax is not supported" appears. 

Her's the expression: 

Sum( 
$map( 
" 
If($esc($csearch([Final_Test],"datatype:single")) > ColumnProperty( $esc($csearch([Final_Test],"datatype:single")),'Limits.Spec.Upper' ) 
Or 
$esc($csearch([Final_Test],"datatype:single")) < ColumnProperty( $esc($csearch([Final_Test],"datatype:single")),'Limits.Spec.Lower' ), 1, 0)",", 
" 
) 
) 




We followed the syntax in the "Insert Function" area, and we keep seeing this warning. 

"Since the expressions are using Column property which by nature is dynamic, the expression becomes dynamic.

For any transformation to be added in Spotfire, we would need the calculation result into static values instead of dynamic."

The following expression example has been provided by TIBCO's supporters to overcome the issue: Sum(If([Scrap Yield] > ColumnProperty( [Scrap Yield],'Limits.Spec.Upper' ) or [Scrap Yield] < ColumnProperty( [Scrap Yield],'Limits.Spec.Lower' ),1,0)) . Similarly, we have to add an expression for all the column names which are being used at your end and in the future if more columns are added in the data table then you have to manually add those column condition check in the expression.

As a workaround, TIBCO supporters have attached a text file which contains all the current column present inside the analysis file along with expression(logic) used.
Thanks, 

Best Regards,