Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I would like to create an iterated interpolation tool through ModelBuilder. I have an excel file containing different columns and each column represents a data that will be interpolated using Spline Tool. How can I do this through ModelBuilder? I am using ArcGIS 10.

enter image description here

Image contains point data with lat/long and sample# are the columns to be interpolated.

share|improve this question
up vote 4 down vote accepted

The following model will achieve what you require:

Iterate over fields

  • Your screen shot shows fields SAMPLE 1 to 9 so set the For iterator to this.
  • Convert your lat/long into an event layer which feeds into the Spline tool. Note the use of in-line substitution to create the field name that will be the Z field. The same is used to create unique output raster names.
share|improve this answer
Hi, Hornbydd: May I know where is the connecting arrow between "FOR" and "Sheet1$ event"? – user2543 Apr 12 '14 at 8:50
There is no connection, the iterator controls the whole model and is generating a variable called value which you use inline substitution to make use of it. – Hornbydd Apr 12 '14 at 12:32
Hi, Hornbydd: I tried the model you posted and I got similar range of values from SAMPLE1.tif to SAMPLE9.tif. I am not sure what went wrong. – user2543 Apr 14 '14 at 8:01
Did you ensure you Z value field was set to: SAMPLE%Value% – Hornbydd Apr 14 '14 at 8:42
thank you. i went back to your model and it worked! – user2543 May 7 '14 at 2:08

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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