topic Re: ArcMap Iterator and Model Builder in ArcMap Questions

ArcMap Iterator and Model Builder

DanCrawford_work — Sat, 18 Feb 2023 03:01:42 GMT

ArcMap 10.8

Hello, I'm having difficulty using the iterator in my model. This is what I want it to do:

Iterate through a list of SDE feature classes
For each SDE layer, make a temporary feature layer
Take that feature layer and perform a selection by location
Append the selected features into an existing geodatabase feature class.

So my model works perfectly except that the attributes are not being carried forward to my geodatabase feature class. The spatial data, in this case lines, comes over.
I know it's not an attribute compatibility issue as it works when done manually.

Not sure what I'm doing wrong... any suggestions would be appreciated.

Re: ArcMap Iterator and Model Builder

DavidPike — Sat, 18 Feb 2023 12:38:34 GMT

Do your Schemas match? Seems like they probably don't and you have "NO_TEST" set on the append tool.

Re: ArcMap Iterator and Model Builder

DanCrawford — Sat, 18 Feb 2023 19:06:28 GMT

Thank-you for the suggestion.
I tried appending to a new layer which was built using the same schema as the input data set. Same result unfortunately. Strange thing is, I can copy and paste the features in ArcMap and the attributes come over.

Re: ArcMap Iterator and Model Builder

DavidPike — Sat, 18 Feb 2023 19:12:50 GMT

Did you refresh the field mapping in the Append when you changed the input? I'd delete that append and recreate it just to be sure. What happens when you use merge in the model instead of append? If that copies all the fields across then it means the issue is definitely with how your append is set up.

Re: ArcMap Iterator and Model Builder

DanCrawford — Sat, 18 Feb 2023 19:43:46 GMT

Thank-you again.

Tried deleting and rebuilding the append process but had the same issue.
Merge was a non starter as the process wouldn't allow me to use a variable as an input.
What does seem to work (I need to test more extensively) is to copy the selected features to a temporary feature class in front of the append. When I append that layer, the attributes come over.

Re: ArcMap Iterator and Model Builder

DavidPike — Sat, 18 Feb 2023 20:07:18 GMT

strange, but if it works. Just fyiu there is an in_memory workspace which may save you some clutter https://desktop.arcgis.com/en/arcmap/latest/analyze/modelbuilder/the-in-memory-workspace.htm

e.g. Copy Features output location -> in_memory/%Values%_CopiedSelection

Re: ArcMap Iterator and Model Builder

DanCrawford — Sat, 18 Feb 2023 22:02:53 GMT

Thanks for the tip. I'll try that.

Re: ArcMap Iterator and Model Builder

MichaelVolz — Sat, 18 Feb 2023 22:42:55 GMT

Have you considered exporting the model to a python script?

Re: ArcMap Iterator and Model Builder

DanCrawford — Sun, 19 Feb 2023 17:18:53 GMT

I'm afraid I'm not a python programmer.