Skip to main content
Solved

Unable to remove duplicate attributes

  • December 3, 2015
  • 3 replies
  • 15 views
mapper
Contributor
Forum|alt.badge.img+2

I am translating data from a SDE database to a file gdb. For some reason there seems to be a second copy of all my attributes (the upper case attributes in the attached image). I can not access these attributes to remove them. Several of the attributes are dates, I used the date formater to change the format of the date. Unfortunatly the dupliacte attributes aren't getting reformated and are causing an error in the writer. I have never seen an error like this and don't know where to start. Any Ideas?

Best answer by mapper

Thanks, using the attributeExposer to expose the upper case attributes and then removing them with the attributeRemover worked. great.

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.

3 replies

takashi
Celebrity
  • takashiCelebrity
  • December 4, 2015

Hi,

If the uppercase attribute names just aren't shown on Workbench interface, you can expose them with the AttributeExposer, and then you can format the date string, remove unnecessary attributes, and so on.

Takashi

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
pratap
Contributor
Forum|alt.badge.img+12
  • pratapContributor
  • Contributor
  • December 4, 2015

Hi,

As far as I understand, SDE DB will have attributes in uppercase and gdb will accept in both cases. It might be case that you are processing both case attributes till the writer i.e. file gdb. As @takashi told remove the attributes either by exposing and removing or use attrbutekeeper before the writer and allow only required attributes to writer.

Pratap

mapper
Contributor
Forum|alt.badge.img+2
  • mapperContributor
  • Author
  • Contributor
  • Best Answer
  • December 4, 2015

Thanks, using the attributeExposer to expose the upper case attributes and then removing them with the attributeRemover worked. great.

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.