Solved

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

  • 21 June 2023
  • 8 replies
  • 127 views
abnan0001
Rank
Badge +6

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

icon

Best answer by nielsgerrits 27 February 2024, 14:55

View original

8 replies

saraatsafe
Rank
Userlevel 2
Badge +7

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
Rank
Badge +6

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
Rank
Badge +6

Sample Excel file of field name and alias is also attached

1 Attachment
abnan0001
Rank
Badge +6

Any Guidance or Suggestion to accomplish this..

Thanks

nielsgerrits
Rank
Badge +39

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
Rank
Badge +6

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
Rank
Badge +39

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.

 

 

1 Attachment
abnan0001
Rank
Badge +6

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

Reply


Community Stats

29,355
Posts
111,610
Replies
37,019
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.