topic Re: Split by attribute in Model Builder in ModelBuilder Questions

Split by attribute in Model Builder

JonathanMori1 — Thu, 18 Jun 2015 14:12:32 GMT

Hi,

I have been attempting this model but I am having a little trouble with one part. The model exports from a SQL Spatial Database using Data Interop Extension , and merges them into one feature class. The problem I am having is that it needs to be split into separate shapefiles based on the "layer" field. I did some research and found that "Iterate Field Values" would be able to do this, but I cannot get it to work right. I attached the toolbox and the Model that I am referring to is M4ExportModel_Points2. I was wondering if anyone could see what I'm missing or what I am doing wrong.

Re: Split by attribute in Model Builder

SepheFox — Thu, 18 Jun 2015 14:18:36 GMT

Can you just put in a screenshot of your model? It is much easier than downloading a zip, etc.

Re: Split by attribute in Model Builder

JonathanMori1 — Thu, 18 Jun 2015 14:40:40 GMT

OK, here is the section after the merge where I am trying to split by attributes. The Expression is ("Layer"=%Value%)

Re: Split by attribute in Model Builder

SepheFox — Thu, 18 Jun 2015 14:44:24 GMT

You didn't mention what happens when you run the model, but try replacing Feature Class to Feature Class with Copy Features.

Re: Split by attribute in Model Builder

DanPatterson_Retired — Thu, 18 Jun 2015 14:49:36 GMT

If you feel like splitting it up as a separate process see Split Layer By Attribute (for version 10.3, a toolbox can be generated for older versions if needed)

Re: Split by attribute in Model Builder

JonathanMori1 — Thu, 18 Jun 2015 15:00:27 GMT

OK Here is the Iterator part I'm having issues with. It runs fine up until then

Executing (Iterate Field Values): IterateFieldValues C:\Users\morij\Desktop\Projects\M4Testing_062015\ModelTest\M4ExportMerge_PointUTM Layer Long true true 0

Start Time: Thu Jun 18 10:56:31 2015

Succeeded at Thu Jun 18 10:56:31 2015 (Elapsed Time: 0.01 seconds)

Re: Split by attribute in Model Builder

JonathanMori1 — Thu, 18 Jun 2015 15:02:10 GMT

Thanks! I have a FoxTools version of this I have been using, but I will try out this one.

Re: Split by attribute in Model Builder

DanPatterson_Retired — Thu, 18 Jun 2015 15:05:11 GMT

check the script in the Fox tools version...I would be curious to see if it is a re-write or mine in a shell

Re: Split by attribute in Model Builder

SepheFox — Thu, 18 Jun 2015 15:14:39 GMT

I'm assuming it just stops at the iterator. I just noticed the problem. After the iterator you need to insert Select by Attribute, and use the Value variable in your selection query, then you can connect that to copy features.

Re: Split by attribute in Model Builder

JonathanMori1 — Thu, 18 Jun 2015 15:15:41 GMT

I am trying the copy features tool as you suggested and Iterate Feature Selections with a "group by" Layer

Re: Split by attribute in Model Builder

JonathanMori1 — Thu, 18 Jun 2015 20:18:29 GMT

What I had to do is create another model, because I got it somewhat working, but it would go through whole the model again for each iteration and take forever. The new one only has the "Iterate Feature Selection" as seen below, it uses the export/merge/projected shapefile from the other model.

This seems to be working pretty well.

Re: Split by attribute in Model Builder

SepheFox — Thu, 18 Jun 2015 20:25:32 GMT

Great! You can make a submodel out of this and put it in your larger model.