How can I achieve this in FME?
Thanks
I'm a starter and would like to know how to perform a simple transformation in FME desktop edition. My source data has a INT column filled with data ranging 1 to 5. I wish to do an ETL and would want to Write this column to be a boolean in my destination database , such that 1 = TRUE(0) and 2 to 5 = FALSE(1).
Page 1 / 1
Hi,
This article is describing the usage of several transformers which you can use to do that.
FME 2013-SP1: Conditional Processing in FME
http://blog.safe.com/2013/03/fmeevangelist113/
I would use "Conditinal Mapping" functionality of the AttributeCreator (FME 2013 SP1 or later).
Takashi
Hi,
An alternative to Takashi's method would be using the AttributeValueMapper.
Itay
Yeah, the AttributeValueMapper could be simpler in this case; you can specify FALSE(1) to Default Value, map 1 to TRUE(0).
# I found the FME Evangelist blog has moved to the Safe Software Blog (About FME category). Have you known?
http://blog.safe.com/
Yes, they have moved it and merged all Safe blogs into one some time now.