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

How dose TERR treat empty cells in Spotfire


Rui Li

Recommended Posts

Hello everyone,

I have a datasheet with some empty entries in Spotfire. I would like to creat a IF-ELSE loop in TERR script to test if cell in column Ahas a value, if yes, copy that value to column C, if not, copy value from column B to C.

I tried a couple things, like is.null, cell == "", or cell == 0. None of them worked. So how does TERR treat these empty cells (I found they are numerical value with a length of 1) How should I use a logic test here

I have uploaed an example data file.

Thank you!

Rui

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...