Skip to main content
  • EN

Is there any function exists in FEM equivalent to oracle function decode.

DECODE(supplying_code, 1, 'Oracle',

2, 'FME',

3, 'ArcGIS',

'GIS') result

The math operator maybe :

? : (x?y:z)

http://docs.safe.com/fme/2019.2/html/FME_Desktop_Documentation/FME_Workbench/!Transformer_Parameters/math_operators.htm

I would say the AttributeValueMapper is the closest equivalent, although you could also get the same results in e.g. an AttributeCreator or AttributeManager using a conditional value.

 

Reply


Community Stats

30,159
Posts
114,479
Replies
37,803
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.