field calculate in parcel fabric

Question

I have hundreds of PIN numbers to change in the fabric from township PIN’s to City PIN’s.

I have a spreadsheet with a “new” PIN column and an “old” PIN column.

Do you know of a way to join the table based on the old pin column and then just calculate the joined pins to be new pins?

jcarlson · Accepted Answer

Hey Brett!

There are lots of ways you might accomplish this sort of thing, depending on what you're comfortable with, how your data looks, and what program you're using. The process you describe is straightforward enough. Here's how.

Given a parcels layer and a newpins table (this can be any tabular dataset added to your workspace), use the Add Join GP tool to join the tabular data to your parcels by the appropriate field.

Verify that your data is joined in the way you intended. The attribute table should have the new pins correctly joined to your parcels now. In order to make that data permanent, but without creating a new layer or field, use the Calculate Field GP. Specify the existing PIN field, and simply set it equal to the joined newpin field.

After running, your PINs should be updated. Because the old PIN values were used in the join, the joined fields should now appear null. Feel free to run the Remove Join GP tool at this point, and you're done!