New to this and have trial of ARCGISPRO. I have a table and I added a new field. I now want to copy about 2000 data points from excel and paste in that field. I can get it to paste ONE, but not the entire column. Any help? Thank you. ARCGIS newbie 😉 excel field table editing import fields
If they have a common id field, then you should be doing a 'join' to simplify the operation.
I'm sorry but could you elaborate. I do know how to JOIN, but if I have an excel file with the field (common field to the table in GIS) then what is the operation? THANKS!
thank u
Another option, if you want to add the columns permanently
Join Field—Data Management toolbox | ArcGIS Desktop
As Dan mentioned, do the excel-to-table first, and I would use the add-join (or Add Relate ) to test the results (both which can be temporary, or at least do not permanently/physically add the fields), but then if you want it permanently added to you table, use the Join Field to add the columns to the in_data....you can also filter for just the columns you want. The in_field and join_field do not have to be the same name, but do need to have equal values (which is why testing first is helpful.
JoinField_management (in_data, in_field, join_table, join_field, {fields})
If the columns do not add correctly or you get too many fields added, you can always use Delete Field—Data Management toolbox | ArcGIS Desktop
Keep in mind that if you add fields, and there is already a field with that name, the new fields will get a _1 added to the new fieldname (at least in Desktop...assuming same in Pro)
Just some options...but I would go with Dan's suggestion first.
thank you both - i will give this a try.