|
Did you simply try my_attribute = ""?
----------------------------------------------------------------
Olivier
Gayte
Veremes
http://www.veremes.com/
42 av. des
Jardins
66240 St Esteve
France
tél +33 (0)4-68-38-65-27
mobile +33
(0)6-60-49-83-81
fax +33 (0)4-26-68-98-35
[EMAIL PROTECTED]
----------------------------------------------------------------
----- Original Message -----
Sent: Monday, July 11, 2005 6:05 PM
Subject: [fme] Using Joiner with
attribute having NULL value
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.
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
|
