topic Re: Field name of Extract multi values to points changes for repeated run in Model Builder in Geoprocessing Questions

Field name of Extract multi values to points changes for repeated run in Model Builder

ChamnabEM — Thu, 14 Sep 2017 18:16:26 GMT

Hi,

I am using Model Builder using: extract multi values to points from a raster, and then use the extracted value as input feature of building another raster.

My problem is that after create the Model, when I run first time, it worked well but from second time it didn't work because every time I run it, the new field was created with number at the end, and the raster building read only the first field that was set.

Ex: In the Model, in field name "vegetation" was set to extract multi value to points and raster building. For running from second time, the filed name created from extract value to points turned to "vegetati_1", "vegetati_2"... while the setting in raster builder was still to read field "vegetation". So that the raster created found no changes even if the input data was changed.

Could anyone share your idea on this?

Re: Field name of Extract multi values to points changes for repeated run in Model Builder

DanPatterson_Retired — Thu, 14 Sep 2017 18:24:11 GMT

the help topic suggests making a copy of the input first since the tool modifies inputs... do that and work on the copy then your field name will not change

Re: Field name of Extract multi values to points changes for repeated run in Model Builder

ChamnabEM — Thu, 14 Sep 2017 21:15:04 GMT

Thanks Dan.

Maybe my expression was not good. When using Extract values to points, it will create a new field in the input. And that new field will be create more and more as much as we run the extraction such as: "vegetation", "vegetati_1", "vegetati_2".... I need to use it in the model builder where field "vegetation" is used in next calculation, and I don't want to go to change the field setting everytime I run.

Re: Field name of Extract multi values to points changes for repeated run in Model Builder

DanPatterson_Retired — Thu, 14 Sep 2017 21:22:13 GMT

I don't have any suggestions, perhaps this is where python would be better

Re: Field name of Extract multi values to points changes for repeated run in Model Builder

ChrisDonohue__GISP — Thu, 14 Sep 2017 22:23:39 GMT

Just a quick thought on a workaround - add a process after the first Extract to Points output to rename the offending field to what is needed for the input before doing the next iteration. For example, Alter Field (Data Managment) could be used to rename the field.

Alter Field—Data Management toolbox | ArcGIS Desktop

Outside of that, it would probably be helpful to see what the model looks like to get a sense of how things are currently structured. There possibly may also be some options to use In-Line Variable Substitution or other methods to resolve this, but it depends on how it all is currently set up.

Examples of inline model variable substitution—Help | ArcGIS for Desktop

Ultimately, if you will be doing this process often and are comfortable with Python, I'd go with the suggestion by Dan_Patterson and use Python instead. Modelbuilder can be useful but it is quirky in some ways.

Chris Donohue, GISP

Re: Field name of Extract multi values to points changes for repeated run in Model Builder

ChamnabEM — Thu, 14 Sep 2017 23:53:58 GMT

I am so new to python. I will manage some times on Python. Thanks Dan.

Re: Field name of Extract multi values to points changes for repeated run in Model Builder

ChamnabEM — Fri, 15 Sep 2017 00:09:10 GMT

Hi Chris.

Thank for your suggestions. Attached image is a part of Model that I want to build. In this model, I need to select Field to use of each input. But I don't want to select it all the time and I want something do it for me in the model.

First run, it created field vegetation, second run it created field vegetation_1, and so on. The image is the 3rd run diagram. But I want to use the latest one every time I run the total model without go to change it all the time, so that the end-result of the total model will be correct by using correct data.

About Python, I am new to it but I will manage some times later to learn.

I hope I can get more workaround on this.

Re: Field name of Extract multi values to points changes for repeated run in Model Builder

ChamnabEM — Fri, 22 Sep 2017 03:15:37 GMT

As this was not solved, I remake the confirmation.

I just want the extracted value from raster to only one field every time I run the model, as it was automatically create new field when repeated running.

Is there any workaround for this?

Re: Field name of Extract multi values to points changes for repeated run in Model Builder

DanPatterson_Retired — Fri, 22 Sep 2017 03:39:44 GMT

As I suggested earlier, each time you run your model you should work with a copy of the input file, in that way the next time you run it, the input file has not been altered and the added fields won't exist in the original.

Re: Field name of Extract multi values to points changes for repeated run in Model Builder

ChamnabEM — Fri, 22 Sep 2017 08:06:24 GMT

Hello Dan,

Is this scheme as what you mentioned?

Re: Field name of Extract multi values to points changes for repeated run in Model Builder

DanPatterson_Retired — Fri, 22 Sep 2017 10:23:37 GMT

Can't confirm, I do Python not Modelbuilder, but give it a whirl and report back

Re: Field name of Extract multi values to points changes for repeated run in Model Builder

KedaravindanBhaskar — Wed, 22 Sep 2021 08:32:22 GMT

Hello Chamnab,

I've faced a similar problem and found that deleting the newly created fields from the attribute table of the output of the Extract Multi-Value to Point tool allowed you to reset the output name. It is a bit tedious but this option worked best for me.

Hope you find this useful.