Accepted Solutions
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!
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!
