InaPlex Forums

Hi David, I receive the following error when using 2 iif functions: iif(lcase(#[Name_title])='de heer','Male',iif(lcase(#[Name_title])='mevrouw','Female','Unknown')) Expression produced the following error: Exception thrown when evaluating function iif(. Exception Type: java.util.EmtptyStackException Message: null (I would prefer a case function instead of multiple iif's but I could not find this in the documentation) Any ideas? Kind regards, Jaco van der Laan Consilium CRM Solutions Rotterdam - The Netherlands

Hi Jaco

Sorry, but the iff() function does not support nesting, and for exotic reasons in the parser it is unlikley to ever support it.

You can achieve the same result using a couple of tests in tab 4. Alternatively, have a look at the textmap() function - this gives you case like functionality, with the addition of regular expression support, so your tests could be case insensitive for example.

Regards

Admin

Hi David, Thanks for the quick reply. I have implemented the textmap() function and this solves this problem. Just wanted to be sure that (1) nested iif's are not possible (2) there is no case() statement. Kind regards, Jaco