Hi Olivier, In FME2005 there is a new transformer called NullAttributeReplacer - it will replace all null values for an attribute with a default value of your choosing.
Hope this helps, Regards, Mark Mark Ireland, Product Support Engineer Safe Software Inc. Surrey, BC, CANADA [EMAIL PROTECTED] http://www.safe.com Solutions for Spatial Data Translation, Distribution and Access --- In [email protected], [EMAIL PROTECTED] wrote: > Hi, > > I am using a joiner to join DGN file to Oracle table. A field in this > joined table is null. I want to make a kind of NVL (within Oracle, NVL > could change null value to something else). > > How can I specify a check on a null value to transform it to something > different (in this case -1) ? > Is there any transformation filter or check able to deal with Oracle null > value ? > I tried to use a TESTER on that field after the join, but how could I specify the test ? Someting like : "my_attribute = NULL " ??? > > Thank you very much for your answer, > > Olivier Dubois Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our Professional Services team. Visit www.safe.com/services for details. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
