Geographic Information Systems Asked on August 3, 2021
I have datasets in a File GDB Feature Class and an Excel table. I want to join them on a field named JOINFIELD. I have the same field name in the FC & in the top line of a column in the Excel sheet. When I am choosing the fields for the join I see the one in the FC, then I select the Excel file to join to it but the drop down menu does not show my JOINFIELD from the excel file, so I can not join on it.
If I do the reverse, bring the Excel table into ArcMap and try to join to the spatial FC I do see the JOINFIELD in the Excel table join options but once I point to the FC to join to the JOINFIELD does not appear in the drop down menu of fields to join on from the FC, even though I know it is there.
I have tried changing the Excel file to .csv but no change.
The values in the JOINFIELD are numeric and I have confirmed they are identical in both the FC and the Excel table. There is only 4 records so it should have little problem joining.
Why do the fields not show for joining?
Join fields have to be the same basic data type (text vs. number). In a table read in from Excel that is wildly uncertain depending on the contents of the column. It's safer to convert it to a real database table.
Answered by Jersey Andy on August 3, 2021
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP