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.
---- LSpots keywords ?> ---- HM ADS ?>
YAHOO! GROUPS LINKS
- Visit your group "fme" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
