Jump to content
We've recently updated our Privacy Statement, available here. ×

Converting an Excel statement to Spotfire Expression


Damilola Adeyemi

Recommended Posts

Hi Team,

I have been trying to get this expression working.I have been struggling with the conversion syntax in Spotfire, trying to compare a string with an integer.

Please help

Case

 

When Len([ComsumerID] = 5 ) then "Individual"

 

ELSE "Other"

 

End

 

Excel function and it worked

=IF(LEN(I2)=5,"Individual","Other")

Link to comment
Share on other sites

It is not conversion syntax. There is a misplaced parenthesis: you are not closing the round bracket after the square.

Case

When Len([ComsumerID]) = 5 then "Individual"

ELSE "Other"

End

Please also check the column spelling (unless it is actually spelled with m in your data).

Gaia

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...