I think the Tester would be the tool to use. This would split the values to
different outputs (match/nonmatch), each of which could be set up with
different attribute sources.
--Bill
William G Voigt (415) 485-3366 voice
GIS Analyst (415) 485-3334 fax
Dept Public Works 111 Morphew St
City of San Rafael San Rafael, CA 94901
+++++++++++++++++++++++++++++++++++++++++++
Date: Thu, 11 Aug 2005 07:29:05 +0100
From: "Vinesh Govind" <[EMAIL PROTECTED]>
Subject: FME.......using If statement
I want to be able to do a lookup from an oracle table to substitute for
a input value when a particular circumstance is met.
Two tables related by site_id. Each application number may have zero or
one sites
Application_details
application_no
site_id
address_is
Site
site_id
address_id
If the value of site_id in the application_details table is zero then
lookup a value in the site table to use in its place.
if application_details.site_id = 0 then
output the value of application_details.address_id
else
output the value of site.address_id where site.site_id =
application_details.site_id
end if
Vinesh Govind
Information Management Team
Pen Lloyd Building - Room G48
Chief Executives Department
Leicestershire County Council
(T) (0116) 265 7321
http://www.leicestershire.gov.uk
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/
