0

ModelIterateXLSFiles

Using ModelBuilder in ArcGIS 10.2 I want to iterate through a folder containing .xls-files, convert them to tables, and merge them into one Shapefile.

I tried the script Excel To Table, with and without the Collect Values tool, the model runs, but it gives no output at all.

What is wrong with my model?

  • The Excep docs, d they contain xy coordinates? A merge only works with features and shapefiles. If you have coordinates perhaps the the create xy event layer and then merge. – Keagan Allan Apr 9 '18 at 17:16
  • Yes, the records do contain xy coordinates. I will try your suggestion. Thank you! – Rusty Apr 9 '18 at 17:46
  • 1
    Your model is inefficient as you are merging on each iteration, your model will run considerably faster if you build your model correctly. See my answer this question and try to understand the use of sub-models. – Hornbydd Apr 9 '18 at 18:00
  • I will check that out and make changes accordingly. I appreciate the help. – Rusty Apr 9 '18 at 18:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.