Model builder for csv file to update feature class

1238
1
05-24-2017 10:35 AM
TrentonCross
New Contributor

I am trying to use Model Builder to update our buildings layer with new solar panels. The solar panel data is saved in an excel file (now converted to .CSV file). I am new to model builder, so I am not sure where to start. We are using Model Builder a. for the experience and b. because this will be a repeated process used to continuously update our buildings layer as new solar panels come in. Again, I am new to this so I am not sure where to start but we are looking at using a merge or join.  I also can't seem to find any tutorials that are doing anything similar. Any advice or pointing in the right direction is appreciated!!

Tags (2)
0 Kudos
1 Reply
curtvprice
MVP Esteemed Contributor

My suggestion, is to first figure out how to do your workflow with the tools one at a time. I think these tools are what you're looking for:

Make Feature Layer

Add Join

Calculate Field

Delete (the feature layer - with its join)

Once you know how to do this, it's a matter of dragging the tools to Model Builder, connecting them together and running the model. (There may be some debugging to do in there as well!)

What is ModelBuilder?—Help | ArcGIS for Desktop 

Here's a video on how it works in Pro! Very similar to ArcMap. This 2 minutes demo goes really fast -- but gives you an idea of the process.

Make a geoprocessing model in Pro