1

Is there an ArcMap 10.1 method for selecting only attribute rows that have an identifier in common with those in a CSV sheet?

I exported an attribute table (5000 rows) and eliminated all but the specific 257 rows I am interested in (based on an APN number). The resulting CSV has the same number of columns with the same headings, just fewer number of rows. Now I am having trouble figuring out how to map only the rows from the attribute table that I am interested in.

Doing a join just appends the tables, but doesn't get me to my goal of eliminating the attribute rows that aren't in my CSV sheet.

  • Just select the rows in the joined table where csv.APN_number IS NULL (in the second APN Number field from the CSV, not the original APN Number field). – Son of a Beach Dec 17 '19 at 1:22
2

Right click on the attribute table and click the join choice. The Join Data window has a choice that says keep all records or Keep only matching records to create the target table.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.