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.
Solved
Why is FeatureJoiner Joining but not showing joined data?
Best answer by lars_de_vries
This looks like ArcGIS attachments. Probably the REL_GLOBALID doesn't use accolades, where GLOBALID does.
+18- Contributor
Select a feature and check the attributes in the Feature description window.
The attributes are joined, but not exposed (they are available, but hidden).
erik_jan wrote:
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)
+10This looks like ArcGIS attachments. Probably the REL_GLOBALID doesn't use accolades, where GLOBALID does.
lars_de_vries wrote:
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
jasonclemis wrote:
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
+18- Contributor
jasonclemis wrote:
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.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.