Trying to use AttributeValueMapper to set one column's value based on the value of another column but it is not working. I can use it to map single values but I need to do it with ranges of values.

I am able to use AttributeValueMapper to translate single values (ie if col1 == 1 then col2 = 'A') but I need to get it to map ranges of values, something like

if (col1 > 0 AND col1 <= 50) then col2 = 'A'

I keep getting 'Invalid Test Expression' errors so it sounds like I'm not writing the conditional tests correctly but I cannot see where I'm going wrong. Here's an example:

Can anybody help me fix this, or point me at another way of setting a value in one column based on more than one possible value in another column?

Thanks,

Mike