2 Replies Latest reply on Sep 30, 2011 12:40 AM by Zubher

    Copy Field From Attribute Table to Another?

      Good Day

      How does one copy an entire field set from one attribute table to a completly different one (Both are Shape Files).

      your assisstance will be highly appreciated
      Kind Regards: Zubher
        • Re: Copy Field From Attribute Table to Another?
          If your tables share an attribute table field and value, you can join on that field. If you have many fields to add or update export to a new shapefile and delete the fields you don't want. If you only have a field or two to update, add them to the target shapefile and use the calculator to copy from the joined table to the new, then remove the join.

          If the tables share no linking fields, you could try a spatial join but that will need checking to be sure it worked properly with odd shaped polygons.  If the tables are by default sorted such that each row matches that in the other, you could make a copy of your shapefiles, and then open the dbfs in Excel (older than 2010) or Open Office's spreadsheet, and then copy and paste fields from the source dbf to the target, then delete the fields you don't want.  Don't sort and don't touch the shape field.

          One other possible option if your license allows, the shapes match very closely and you want to replace the entire table.  Use the Polygon to Lines and Polygon to Points (inside polygon checked) tools on both shapefiles.  Then use the lines from the target layer and points from the source to build new polygons with new attributes.
          • Re: Copy Field From Attribute Table to Another?
            Thank You For your assistance John :)

            I tried the Spatial Join technique and it worked

            Much Appreciation