topic Re: Field Map In Model Builder in ModelBuilder Questions

Field Map In Model Builder

DavidCampbell — Thu, 20 Nov 2014 20:12:29 GMT

Hi All,

I have a model that has a feature class to feature class inside of it with an iterate. As the first iterated item goes into the FC2FC it loads the field map with all of its fields. I need to drop all field map fields before each iteration of the FC2FC. Once before the tool starts iterating and then successively after each iteration. I cannot find anywhere how to delete the field map (bring all fields in input to the output).

Thanks,

David

Re: Field Map In Model Builder

ChrisDonohue__GISP — Thu, 20 Nov 2014 20:44:41 GMT

To clarify what you want, is the goal to not have certain fields transferred from the input to the output?

Chris Donohue, GISP

Re: Field Map In Model Builder

DavidCampbell — Thu, 20 Nov 2014 20:58:01 GMT

The goal is to have the fields of the input file to make it to the output. Fields from the last iteration are staying in so when there are new fields it the field map does not contain them. If the field map was removed, it would populate with the newest inputs fields and forget about the time before.

Does that clarify?

Thanks

Re: Field Map In Model Builder

ChrisDonohue__GISP — Thu, 20 Nov 2014 21:07:54 GMT

That clarifies it.

Can you post an image of your model schematic? I'm curious why the new fields would not be carried over. Seeing the model components may help in identifying what is going on.

Re: Field Map In Model Builder

DavidCampbell — Thu, 20 Nov 2014 21:12:16 GMT

Here you go!

Re: Field Map In Model Builder

ChrisDonohue__GISP — Thu, 20 Nov 2014 21:18:20 GMT

When you look at the outputs of each process step, at which point is the data not being transferred?

Also, what process is being done in the "Get Field Value"?

Re: Field Map In Model Builder

DavidCampbell — Thu, 20 Nov 2014 21:20:22 GMT

Get field value gets the area that is being clipped's name in order to name the new files created. The step is the feature class to feature class at the end. The field map is populated after the first feature goes into the tool and it won't forget it.

Re: Field Map In Model Builder

ChrisDonohue__GISP — Thu, 20 Nov 2014 21:30:32 GMT

Forgive me if I am missing something obvious, but I don't see any processes that would differentially add fields, so therefore it seems all the fields would be constant. What is causing there to be different fields between iterations? ( I realize there may be scripts and coding hidden in the model that can't be seen in the image)

Knowing where processes are adding/removing fields would help in troubleshooting this.

Re: Field Map In Model Builder

ChrisDonohue__GISP — Thu, 20 Nov 2014 21:39:46 GMT

I think I just figured out what the potential issue is. The final Feature Class to Feature Class is going from a Coverage to a Shapefile. Not a problem in general, however, there are often field name issues when transferring data from a coverage to a shapefile (and reverse). For example, field names that are OK in one file type are not OK in the other due to the differing restricted characters, allowed field lengths, etc. This can cause data to not transfer correctly.

Re: Field Map In Model Builder

DavidCampbell — Thu, 20 Nov 2014 21:45:29 GMT

Each iteration creates a new filename going into the feature class to coverage. This affects an interior ID field for tracking features within the coverage.

Is there a tool or something I can attach as a precondition to delete the field map?

Re: Field Map In Model Builder

ChrisDonohue__GISP — Thu, 20 Nov 2014 21:55:57 GMT

Here's a reference:

Field names cannot be longer than 10 characters.

Geoprocessing considerations for shapefile output

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002t0000000m000000

There are also specific known restricted character issues that are commonly run into when converting from Coverages to Shapefiles. I used to have a link to a nice information page on that, but I'm not finding that information so far (and I lost the bookmark for it).

Re: Field Map In Model Builder

ChrisDonohue__GISP — Thu, 20 Nov 2014 21:58:54 GMT

That I don't know.

Somewhat related, there is a Delete Fields tool. But I'm not sure if a workaround with that will help.

Re: Field Map In Model Builder

DavidCampbell — Thu, 20 Nov 2014 22:01:50 GMT

Thanks, but how does this relate to my problem?? Field names themselves are not my issue, it is their presence or absence in the field map of the feature class to feature class tool.

How do I delete a field map as a precondition to running FC2FC?

Re: Field Map In Model Builder

FrankDougher1 — Thu, 12 Jul 2018 14:21:32 GMT

David:

I apologize for dragging up a four year old post, but I'm having the same issue and I was wondering if you ever found a solution in model builder?

It looks like there are Python options for creating a new field map, but none that I'm aware of in Model Builder.

Thanks!