Solved! Go to Solution.
Hello,
I run the model using ADD JOIN instead of JOIN FIELD tool but the result is the same (i.e., it is slower than when I worked with shapefiles). The problem I think is the copy features tool (at the end of the process). It takes four hours to process this step. Any recomendation?
I send you a better version of the Model Builder:
[ATTACH=CONFIG]28510[/ATTACH]
Thank you very much.
Hi,
I have joined an excel table to a shapefile with multiple registers (more than 200,000) and I�??m trying to export it as a new shapefile but it takes more than 4 hours to do it. Does anybody know another way to do it?
I have to repeat the process more that 16 times (using Model Builder) and I need to find a faster way to do it.
Any help will be much appreciated !!
Thank you.
Thanks for your answer. It seems very promising but ... I haven't worked with geodatabase files. Could you please explain me more in detail these steps ??
Thank you very much!!
Hello,
Thanks for the explanation. I was able to run the model, but ... unfortunately is not running faster than before.
I send you the Model I have generated and I would really appreciate your feedback if you find any error.
[ATTACH=CONFIG]28443[/ATTACH].
Some specific questions I was not sured when I generate the model:
1. I use the tool Join Field and not Add field in the model. Is that correct ?
2. When I used the Copy Feature tool I saved the feature within the geodatabase folder. Is that correct ?
3. In the last step (Feature Class to Feature Class tool), I was not sured how I had to do it, so I saved the final shapefile in a folder, NOT in the geogatabase folder. Is that correct ???
Thank you very very much.
Hello,
I run the model using ADD JOIN instead of JOIN FIELD tool but the result is the same (i.e., it is slower than when I worked with shapefiles). The problem I think is the copy features tool (at the end of the process). It takes four hours to process this step. Any recomendation?
I send you a better version of the Model Builder:
[ATTACH=CONFIG]28510[/ATTACH]
Thank you very much.
Yes, that was it. I created a File Geodatabase and now it only takes 5 minutes to conduct the join and create the shapefile. That is great !!
Thank you very much for all your help !