Skip to main content
Solved

Simple tranformation during ETL, transform INT type to BOOL

  • October 14, 2013
  • 4 replies
  • 12 views
D
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).

 

How can I achieve this in FME?

 

 

Thanks

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/
View original
    Did this help you find an answer to your question?
    This post is closed to further activity.
    It may be a question with a best answer, an implemented idea, or just a post needing no comment.
    If you have a follow-up or related question, 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.

    4 replies

    takashi
    Influencer
    • takashiInfluencer
    • October 14, 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
    fmelizard
    Safer
    Forum|alt.badge.img+18
    • fmelizardSafer
    • Safer
    • October 14, 2013
    Hi,

     

     

    An alternative to Takashi's method would be using the AttributeValueMapper.

     

     

    Itay
    takashi
    Influencer
    • takashiInfluencer
    • Best Answer
    • October 14, 2013
    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/
    fmelizard
    Safer
    Forum|alt.badge.img+18
    • fmelizardSafer
    • Safer
    • October 14, 2013
    Yes, they have moved it and merged all Safe blogs into one some time now.

    Helpful Members This Week

    Community Stats

    31,328
    Posts
    118,859
    Replies
    38,956
    Members

    Latest FME

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie 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.