How can I achieve this in FME?
Thanks
Best answer by takashi
View original
Simple tranformation during ETL, transform INT type to BOOL
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).
Userlevel 3
+17
- Contributor
- 7538 replies
-
14 October 2013
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
Userlevel 4
+13
- Contributor
- 3725 replies
-
14 October 2013
Hi,
An alternative to Takashi's method would be using the AttributeValueMapper.
Itay
Userlevel 3
+17
- Contributor
- 7538 replies
-
14 October 2013
- Best Answer
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/
Userlevel 4
+13
- Contributor
- 3725 replies
-
14 October 2013
Yes, they have moved it and merged all Safe blogs into one some time now.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.