Solved

fme_feature_type not coming through to writer (excel table)

  • 6 December 2019
  • 4 replies
  • 25 views
W
Badge

Hi everyone, I am relatively new to FME and am seeking assistance for a minor issue I am having. As part of a project I need to create an excel table that contains 9999 from various attributes and from multiple SDE feature classes. My excel table works but I want to include an attribute that indicates which feature class the record is from. I exposed the fme_feature_type attribute but am not table to get it to export out into the Excel table. What might I be missing? Please see the below screenshot. Thanks in advance for your advice and suggestions!

icon

Best answer by erik_jan 6 December 2019, 20:20

View original

4 replies

erik_jan
Rank
Userlevel 2
Badge +12

Did you add the fme_feature_type attribute in the Excel writer feature type on the User Attributes Tab?

If it is listed in the Format attributes only, it will not be written.

Hope this helps.

W
Badge

Did you add the fme_feature_type attribute in the Excel writer feature type on the User Attributes Tab?

If it is listed in the Format attributes only, it will not be written.

Hope this helps.

It shows in the drop down list but yet I don't see it under the user attributes; I tried to add it but it keeps adding extra 00s at the end of the name.

erik_jan
Rank
Userlevel 2
Badge +12

It shows in the drop down list but yet I don't see it under the user attributes; I tried to add it but it keeps adding extra 00s at the end of the name.

I tried and get the same as you.

Your solution will be not to output the attribute as fme_feature_type, but for example as feature_type, like this:

W
Badge

Did you add the fme_feature_type attribute in the Excel writer feature type on the User Attributes Tab?

If it is listed in the Format attributes only, it will not be written.

Hope this helps.

I tried it and success!! Thank you so much erik_jan, that really helps me out!

Reply


Community Stats

28,669
Posts
109,359
Replies
36,531
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.