Timeline for Comparison between two fields of two tables using ArcPy cursors?
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 20, 2016 at 22:21 | comment | added | Richard Fairhurst | The tool makes the two tables able to use the standard Add Join tool to see the fields of the two tables combined into a single tableview in ArcMap. The code I provided will match the two tables, but would not let you create a single tableview of the fields from both tables, since it does not create a single field that can act as a representative key equivalent to the unique multi-field values. | |
| Apr 20, 2016 at 22:14 | comment | added | Richard Fairhurst | You could also use my tool to create a single Long field key in two tables that represents the match between two tables that originally only match on a multi-field key. geonet.esri.com/blogs/richard_fairhurst/2015/06/07/… Options allow you to use -1 to represent unmatched keys. You can flag unmatched in only the second table, unmatched records of either table not found in the other, or assign unique values to all records to see number gaps in either table that misses records from the other. | |
| Apr 20, 2016 at 22:04 | history | edited | Richard Fairhurst | CC BY-SA 3.0 |
added 140 characters in body
|
| Apr 20, 2016 at 21:52 | history | edited | Richard Fairhurst | CC BY-SA 3.0 |
edited body
|
| Apr 20, 2016 at 21:46 | history | edited | Richard Fairhurst | CC BY-SA 3.0 |
deleted 24 characters in body
|
| Apr 20, 2016 at 21:39 | history | answered | Richard Fairhurst | CC BY-SA 3.0 |