Tibco Spotfire 7.5 ~= Operator

Hi All, 

I have an input field into a text area that users use to insert text. This text is stored into a property document "PROP". 

I use "PROP" to search the same text  into a concatenation of 3 fields (A, B, C) of a data table. So, I use the following expression: 

case when  Upper([A+B+C])  ~= Upper('${PROP}') then true else false end

The research is on a datatable of 10mln of record and the results appears after 1 minute.

Is there a way to improve the performance of "~=" operator?

Thank you

1 Comment

You can use the Find function available in Spotfire.

Addy - Sep 07, 2017 - 5:25am
+ Add a Comment