Skip to main content
Solved

Adding Field Alias along with Field Names from excel as a new field..


abnan0001
Supporter
Forum|alt.badge.img+7

Hi Guys..

I need your Guidance to accomplish above scenario..

I was able read a GDB and Excel as source from Feature Reader and also able to do required Results

Now , At attribute Manager , I want to add around 52 new field names along with field alias from importing it throughexcel and this would be new field and then i want to write a GDB , so All field along with other New fields which has alias name to be written to GDB..

 

How can i do this ?

 

Anyone , Kindly Guide..

Thanks

Best answer by nielsgerrits

Not sure why it does not work for you, but it does work for me in both FME 2021 and 2023. It probably has to do with how you set the writer. In my case I set it to Manual and let AttributeA and AttributeB through.

 

 

View original
Did this help you find an answer to your question?

8 replies

saraatsafe
Safer
Forum|alt.badge.img+8
  • Safer
  • June 27, 2023

Hi @abnan0001​, hopefully I'm understanding your question correctly-- please correct me if not. But if you have your Excel sheet with the new field names you can simply attach it to your AttributeManager alongside your FeatureReader output. You can also experiment with transformers like the AttributeRenamer or BulkAttributeRenamer to help.

If you can, please include some screenshots to help illustrate what you'd like to do. I hope this helps get you started!


abnan0001
Supporter
Forum|alt.badge.img+7
  • Author
  • Supporter
  • June 28, 2023

Thank You @saraatsafe for your reply..

let me explain you in detail

The highlighted attribute manager and its results has complete final information in the fields which is required to me and I need few more fields to be added from excel with it field alias name to be added when it is written to GDB.Next screenshot will illustrate that(Fig 2)

 

Fig 1image 

Figure 2

This is the excel which has field name and its field alias name which needs to be added to the attribute manager as new fields with field alias so i have imported this excel file as shown in figure 3

image 

Importing the info from excel imageimage.pngimage 

image 

image 

I was able to import only field names from excel in above figure as highlighted but i need field alias to be shown when written to ESRI GDB...

 

image 

Any guidance, I have in huge number

 

Thanks Again

 


abnan0001
Supporter
Forum|alt.badge.img+7
  • Author
  • Supporter
  • June 28, 2023

Sample Excel file of field name and alias is also attached


abnan0001
Supporter
Forum|alt.badge.img+7
  • Author
  • Supporter
  • February 27, 2024

Any Guidance or Suggestion to accomplish this..

Thanks


nielsgerrits
VIP
Forum|alt.badge.img+53

You have to restructure your excel file so it looks like this:

Then you can do the import:

And you will have the following result:

 


abnan0001
Supporter
Forum|alt.badge.img+7
  • Author
  • Supporter
  • February 27, 2024

Hi 

Thanks for the quick reply.

I have followed the steps as mentioned

But , I see alias name is coming as aseparate field name as shown in snapshot
 

 

 


nielsgerrits
VIP
Forum|alt.badge.img+53
  • Best Answer
  • February 27, 2024

Not sure why it does not work for you, but it does work for me in both FME 2021 and 2023. It probably has to do with how you set the writer. In my case I set it to Manual and let AttributeA and AttributeB through.

 

 


abnan0001
Supporter
Forum|alt.badge.img+7
  • Author
  • Supporter
  • February 28, 2024

Thank You..

I have used feature writer and set the parameters and it worked out..

Where as if i use directly GDB writer it doesnt work.

 

Thanks Again


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings