We have a Mapinfo file with customers and we're using this stupid third party geocoder (for now hopefully changing) and we're pretty sure it's having an issue because of the size of the table we're sending it. I was thinking maybe I could get around it by having FME split the table into 3 equal tables and then geocoding them and then combining them back together. Does anyone know of a way to do this? There's no real column info that I could export based on anything it would have to be after X rows or something similar to that. Thanks so much! 😀
+48- Evangelist
Add a counter, then write to several tables at once, using fanout with [the modulo (math function fmod) of _counter and the number of tables] as part of the table name.
+38- Influencer
Or use the modulo counter, with count maximum set to 3 and then fanout on the_modulo_count attribute.
Note that this will mix up the order of records so you might want to do something differently if the order is important
+48- Evangelist
ebygomm wrote:
Or use the modulo counter, with count maximum set to 3 and then fanout on the_modulo_count attribute.
Note that this will mix up the order of records so you might want to do something differently if the order is important
Nice, I didn't know about the ModuloCounter transformer. It makes the solution even more simple.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.