topic Re: Attribute Value Correction Using ModelBuilder in ModelBuilder Questions

Attribute Value Correction Using ModelBuilder

deleted-user-iwYtitJHBIyn — Tue, 05 Dec 2017 16:22:23 GMT

Hello,

I have a parcel geodatabase that includes site address information. I am new to ModelBuilder but I am hoping it can be used to semi-automate an address correction task.

For example, I would like to be able to correct an address changing the number from "100" to "150". I have a number of these entries to correct with varying numbers and I am hoping the editing can be accomplished using just one model.

Is this possible?

Thanks in advance for any assistance.

Jeff

Re: Attribute Value Correction Using ModelBuilder

curtvprice — Wed, 06 Dec 2017 03:08:56 GMT

Please be more clear what you mean by "semi-automate". Do you want to apply the fix to selected features in a layer or all? Do you want to have the tool do some query to select the features to update, or all features?

Re: Attribute Value Correction Using ModelBuilder

Madanbhurati1 — Wed, 06 Dec 2017 06:14:31 GMT

I am assuming that you have a address field in your parcel feature class And you want to Replace all the occurrences/instances of "100" with "150" for all the parcels. similarly you have other number in address to replace as per your requirement.

There are multiple ways to do it. I would recommend to do it using python script. you will have better control.

You can create a Find and Replace model tool using Calculate Field Geo-Processing Tool.

Following are the snapshot for the model, I used demo feature class with attribute year. however you can use your address field similarly.

I hope it will help you.

Expression Variable is very important to understand

Execute Model it will show you following Input Parameters.

But you have to be certain that you are replacing all the instances of find value.

Re: Attribute Value Correction Using ModelBuilder

deleted-user-iwYtitJHBIyn — Wed, 06 Dec 2017 15:01:17 GMT

Thank you, Madan.

That is most helpful.

Jeff