I am trying to join an ESRI Feature Class to an ESRI Attachment table. It looks like the join is working correctly but it is not showing the attribute information from the Feature Class. I am using a Left join where the Feature Class is joining to the Attachment Table. I am seeing the attributes from the Attachment Table but the attributes from the Feature Class are blank even though there is data in the fields. The data is being joined on a REL_GOBALID and GLOBAL ID field. I verified the data to make sure the data joined in ESRI. i am attaching a couple images. I also noticed that the unjoined right is showing all of the incoming features. As I said I verified outside of FME Desktop that these features should Join. i am stumped.
Page 1 / 1
Select a feature and check the attributes in the Feature description window.
The attributes are joined, but not exposed (they are available, but hidden).
Select a feature and check the attributes in the Feature description window.
The attributes are joined, but not exposed (they are available, but hidden).
The attributes are still blank. I am suspecting that the right part did not join even though the values match (REL_GLOBALID and GLOBALID)
This looks like ArcGIS attachments. Probably the REL_GLOBALID doesn't use accolades, where GLOBALID does.
This looks like ArcGIS attachments. Probably the REL_GLOBALID doesn't use accolades, where GLOBALID does.
Thank you.. that was it..nice catch
The Global ID field had Curly Brackets while the REL_GLOBALID did not which prevented the join. I added Brackets to the REL_GLOBALID and it joined correctly
The Global ID field had Curly Brackets while the REL_GLOBALID did not which prevented the join. I added Brackets to the REL_GLOBALID and it joined correctly
thanks @lars_de_vries
The attributes are still blank. I am suspecting that the right part did not join even though the values match (REL_GLOBALID and GLOBALID)
In that case, the screenshot showing 17 Joined features is misleading.