Timeline for Comparing two tables and appending only the new data
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 17, 2015 at 20:55 | history | edited | D Stone | CC BY-SA 3.0 |
edited body
|
| Nov 17, 2015 at 20:06 | comment | added | D Stone | Fezter- Compare table doesn't give me a selection of records, it just creates a new table and the Add Join tool never contains all the records I need. | |
| Nov 17, 2015 at 20:00 | comment | added | D Stone | Emil- Table 1 has new rows, pretty much always at the end of the table. Table 2 will have had some processing done, mainly calculating values for certain fields and a check on the data to make sure nothing is amiss. | |
| Nov 6, 2015 at 0:00 | answer | added | Chris W | timeline score: 1 | |
| Nov 5, 2015 at 23:53 | comment | added | Chris W | "Best" might get this closed as too broad/opinion based. One approach you might investigate is using nested queries. This requires both tables to be in the same geodatabase though. See my answers at gis.stackexchange.com/questions/103189 and gis.stackexchange.com/questions/110179 related to the concept. Basically once you have both tables in the same geodatabase, you can then use SQL to select all the records not in the other table (or all that are and then invert the selection). Another approach, merge all records and then use Find/Delete identical. | |
| Nov 5, 2015 at 23:50 | comment | added | Fezter | What about the Compare Table or Add Join tools don't work for you? I can see these as the first step in a process which identifies features to add to Table 2. | |
| Nov 5, 2015 at 23:20 | comment | added | Emil Brundage | What sorts of changes occur? New rows added, and/or values updated? If new rows are added, are they always added at the end of the table? Are rows deleted as well? Does order change? | |
| Nov 5, 2015 at 22:34 | history | edited | Vince | CC BY-SA 3.0 |
removed thanks as per policy
|
| Nov 5, 2015 at 21:39 | review | First posts | |||
| Nov 5, 2015 at 21:58 | |||||
| Nov 5, 2015 at 21:35 | history | asked | D Stone | CC BY-SA 3.0 |