How can I achieve this in FME?
Thanks
Solved
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).
Best answer by takashi
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/
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
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
+21- Safer
Hi,
An alternative to Takashi's method would be using the AttributeValueMapper.
Itay
- 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/