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.

Question

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

Page 1 / 1

I probably wouldn't do it in a AttributeValueMapper, id user either an AttributeCreator or AttributeManager. That above range should be fine, but you could also use the following logic

Thanks, hkingsbury. I did it in an AttributeManager and it's working well.

Reply

hkingsbury · Accepted Answer

I probably wouldn't do it in a AttributeValueMapper, id user either an AttributeCreator or AttributeManager. That above range should be fine, but you could also use the following logic

michael_m · Answer

Thanks, hkingsbury.  I did it in an AttributeManager and it's working well.

Reply

Community Stats

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Scanning file for viruses.

This file cannot be downloaded