CODEWITHSUNDEEP
casespotfirecase-when
direwolf
direwolf

Reputation: 121

How to use search for a calculating column in Spotfire

I want to create a calculated column from an existing column for filtering. I am linking the unique values using case statement and it just works with the existing values and it cannot include the search parameters. If i cant do a */% or any type of search i cant include for different variation of the column values that may come in the future. So need to search and substitute through the inbuilt Spotfire functions

My Current Code:

Case  
when [column]=  "Point" then "Value1" 
else "Value2"
end

How I want,but not working cos its not accepting normal search parameters:

  Case  
    when [column] like "%Poi%" then "Value1" 
    else "Value2"
    end

Upvotes: 0

Views: 173

Answers (1)

S3S
S3S

Reputation: 25112

You can't use that SQL syntax in spotfire. Use ~= or RxReplace.

if([column] ~= "Poi+","Value1","Value2")

Or...

case
   when [column] ~= "Poi+" then "Value1"
   else "Value2"
end

Upvotes: 2

Related Questions