Hi Vinesh, For a fixed database (ie it will always be 339000 records) you could use a Counter followed by two testers - one tests for count<=113000 the other tests for count>226000 and the remainder is the middle section.
For an unknown number of records find the maximum count value with a StatisticsCalculator, use an ExpressionEvaluator to divide by three and calculate the intervals and use those values in the Tester (by selecting the attribute holding them). That's splitting the data. To write to three different tables create an attribute (AttributeCreator) that has a different value for each of the three streams of data. Then either... a) route them all into a single output Feature Type with a Feature Type fanout set on the new attribute. This will create 3 tables in the same database - for three separate databases you'd need a Dataset fanout but I'm not sure if that will work with a database format. b) route them into an AttributeFilter and add the different values to filter by. Right-click the AttributeFilter and choose AutoConnect. You can either make new Feature Types or connect to existing ones. Hope this helps, Mark Mark Ireland, Product Support Engineer Safe Software Inc. Surrey, BC, CANADA [EMAIL PROTECTED] http://www.safe.com Solutions for Spatial Data Translation, Distribution and Access --- In [email protected], "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 > _______________________________________________________________________ > 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/
