[fme] FME.......using If statement

Thu, 11 Aug 2005 11:49:23 -0700

Title: 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

_______________________________________________________________________

Leicestershire County Council - rated an 'excellent' council by the Audit Commission

_______________________________________________________________________

 

 

This e-mail and any files transmitted with it are confidential. If you are not the intended recipient, any reading, printing, storage, disclosure, copying or any other action taken in respect of this e-mail is prohibited and may be unlawful. If you are not the intended recipient, please notify the sender immediately by using the reply function and then permanently delete what you have received.

 

Incoming and outgoing e-mail messages are routinely monitored for compliance with Leicestershire County Council's policy on the use of electronic communications. The contents of e-mails may have to be disclosed to a request under the Data Protection Act 1998 and the Freedom of Information Act 2000.

 

The views expressed by the author may not necessarily reflect the views or policies of the Leicestershire County Council.

 

Attachments to e-mail messages may contain viruses that may damage your system. Whilst Leicestershire County Council has taken every reasonable precaution to minimise this risk, we cannot accept any liability for any damage which you sustain as a result of these factors. You are advised to carry out your own virus checks before opening any attachment.

 

 



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



Reply via email to