My Reader is Excel. My Writer is ESRI File Geodatabase. I use AttributeManager to rename the fields. How do I add field name aliases to the Writer in this situation?
Solved
Add Aliases to File Geodatabase
+18- Supporter
- 48 replies
Best answer by dustin
Working with Geodatabase Field Aliases: Altering Alias Values (safe.com) This article will walk you through the methodology.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+31- Influencer
- 627 replies
- Best Answer
Working with Geodatabase Field Aliases: Altering Alias Values (safe.com) This article will walk you through the methodology.
+18- Supporter
- 48 replies
Thank you. I read this article, and it is relevant only if you are reading from a geodatabase. I am reading from an Excel file and writing to a geodatabase. Do you think I need to create a 2nd workspace that I run after I write the feature classes? this 2nd workspace would assign aliases to the feature classes using a geodatabase in the reader. I think this would work, but wondering if there is way to incorporate this workflow into a single workbench?
+14- Contributor
- 102 replies
And what do you think of the answer to this Question: How do I create an alias on an attribute in my FME workspace?
+31- Influencer
- 627 replies
Thank you. I read this article, and it is relevant only if you are reading from a geodatabase. I am reading from an Excel file and writing to a geodatabase. Do you think I need to create a 2nd workspace that I run after I write the feature classes? this 2nd workspace would assign aliases to the feature classes using a geodatabase in the reader. I think this would work, but wondering if there is way to incorporate this workflow into a single workbench?
Check out the Advanced section of the article. It explains how to create aliases from scratch on features writing to geodatabase. In this manner, the input format won't affect your ability to write them.
+18- Supporter
- 48 replies
@egge and @dustin thank you. I read the information. I tried adding the FacilityName_alias (value = FACILITYNAME) to a new field in AttributeManager (not the Writer) and it ends up adding a new field in the feature class named "FacilityName_alias". In ArcMap I checked the field properties for FACILITYNAME, and it still shows the Field Alias as "FACILITYNAME". I would like FACILITYNAME to have the alias "FacilityName".
I think I am missing something, what could it be? thanks.
+31- Influencer
- 627 replies
@egge and @dustin thank you. I read the information. I tried adding the FacilityName_alias (value = FACILITYNAME) to a new field in AttributeManager (not the Writer) and it ends up adding a new field in the feature class named "FacilityName_alias". In ArcMap I checked the field properties for FACILITYNAME, and it still shows the Field Alias as "FACILITYNAME". I would like FACILITYNAME to have the alias "FacilityName".
I think I am missing something, what could it be? thanks.
First, I would imagine it is case sensitive, so it needs to be FACULTYNAME_alias. The Attribute Value of FACULTYNAME_alias needs to be whatever you want the alias to be. As it is now, you are pulling the attribute value from FACULTYNAME, which I don't think is what you want.
+18- Supporter
- 48 replies
@dustin Apologies I must be obtuse today. You pointed me in the right direction, and I finally was able to figure it out. It works. Here is a screenshot of how to insert aliases for anyone else who may need assistance with this.
