Re: [fme] Filtering database

Fri, 29 Jul 2005 08:11:33 -0700

Hello Vinesh
Try using the COUNTER transformer in Workbench and then use TESTERS to filter records:
TESTER1 COUNT<=113000 - Send this to TABLE 1
TESTER2 COUNT>=113001 and COUNT<=226000 - Send this output to TABLE 2
 
And finally whatever remains as FAILED in TESTER2 can be sent to TABLE3
 
HTH
Happy FME-ing
Cheers
SRG
India

Vinesh Govind <[EMAIL PROTECTED]> wrote:

I have a database consisting of 339 000 records.

I would like to split this database into 3 evenly split  tables so that table 1 consists of record 1 to record 113 000, table 2 consists of record 113 001 to record 226 000, and table 3 consists of record 226 001 to record 339 000 records.

Any ideas on how I can do this with FME?

Thanks.

                                         

Vinesh Govind

_______________________________________________________________________

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.

 

 

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

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