I'm doing a model in modelbuilder where I have as input 5 excel tables and what I want is to have 5 outputs in the end of the model. How can I do that?

I want to have 5 outputs after Project tool. The model currently is like this: enter image description here

  • You technically do have 5 outputs if your iterator finds 5 inputs. You need to make sure you're giving each output a unique name. If you want to do something with those outputs, give this a read resources.arcgis.com/en/help/main/10.2/index.html#/…
    – KHibma
    Commented Apr 29, 2015 at 13:57
  • If I use Collect values before Make XY Event Layer, the output enters in Make XY as a precondition, why? And how can I give each output a unique name?
    – AndM
    Commented Apr 29, 2015 at 14:07

1 Answer 1


Are you saying once you run this model you end up with one table, the last worksheet in your workbook? You need to be using inline substitution. Use the Name variable coming out of the iterator in your output featureclass in the project tool. An example would be c:\temp\myData_%Name%.shp

  • Thanks! Now I have 5 outputs. But I noticed another problem, the attributes tables of all outputs only have values in one column, the other two columns are all at 0 and I don't know why
    – AndM
    Commented Apr 30, 2015 at 10:53
  • I bet that's to do with Excel. Have you gone in and used sensible headers and defined the column types? Try that.
    – Hornbydd
    Commented Apr 30, 2015 at 15:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.