Is there a way to add rows by performing a join in Arc 10? Or does a join only insert columns?
- What exactly are you trying to do? Your question isn't clear, I'm not sure what you're asking.
- I am trying to join an excel table to a point file�??s attribute table. In the Excel table I have many rows with same ID number that corresponds to one Id number in the point file�??s Attribute table. So I think it is a many to one join. However when I perform the join it does now create rows.
Point File Attribute Table:
ID Lat Long
44000 62.65412 114.156
44001 62.65412 114.156
44002 62.65412 114.156
44003 62.65412 114.156
Excel Table
ID Temp Precip Rad
44000 20.2 2.3 2.699
44000 15.6 1.3 4.593
44000 14.6 4.5 4.689
44000 18.6 6.4 6.812
44001 6.4 6.1 5.132
44001 20.2 2.3 2.699
44001 15.6 1.3 4.593
44001 14.6 4.5 4.689
Final I want:
Id Lat Long Temp Precip
44000 62.65412 114.156 20.2 2.3
44000 62.65412 114.156 15.6 1.3
44000 62.65412 114.156 14.6 4.5
And so on�?�.. - Add the excel table and point feature to ArcMap.
Instead of joining the excel table to the point feature .... Join the point feature to the excel table.
So right click on the excel table in the TOC and join the point feature to it.
Make sure the data type of the ID field is the same for the table and point feature. - Thank you very much it worked. However I had to export the excel table into dBase table in arc first. It was possible because it was a smaller dataset. Now my problem is that the excel table data is too large to export into dBase formate. I let it run over night and No Export �?. Is there a way to convert the excel documents to dBase without exporting data in Arc???
Thank you very much it worked. However I had to export the excel table into dBase table in arc first. It was possible because it was a smaller dataset. Now my problem is that the excel table data is too large to export into dBase formate. I let it run over night and No Export ??. Is there a way to convert the excel documents to dBase without exporting data in Arc???
Try this...
Create a new file geodatabase/or use an existing one and then use the Excel to Table tool in ArcToolbox and save the output table from the tool into the file geodatabase. I've done this with some pretty massive excel sheets.
Excel to Table tool:
http://resources.arcgis.com/en/help/main/10.2/index.html#//001200000055000000
You should be able to do all this from within ArcCatalog.- This is not working! I am exporting the excel table to convert it into a dBase table so that I can join the dbase table to the point. The Excel to database tool does not convert the table into dbase. Is there a way to convert into dbase format withoutperforming data export in Arc??
Try this...
Create a new file geodatabase/or use an existing one and then use the Excel to Table tool in ArcToolbox and save the output table from the tool into the file geodatabase. I've done this with some pretty massive excel sheets.
Excel to Table tool:
http://resources.arcgis.com/en/help/main/10.2/index.html#//001200000055000000
You should be able to do all this from within ArcCatalog.