Skip to main content
Question

Transformer won't sort attributes

  • May 26, 2014
  • 2 replies
  • 88 views

Using FME Workbench 2014 SP1.

 

Connected a filename part extractor to CSV reader.

 

There are more than two hundred fields and I need to sort them alphabetically to match to the writer which is connected to a legacy database.

 

Right clicking over the output section of the transformer and clicking sort attributes does nothing.

 

Any help appreciated.

 

 

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.

2 replies

Forum|alt.badge.img+4
  • May 26, 2014
Attribute order when writing to a dataset is determined by the writer feature type. 

 

 

Attributes within transformers are automatically aligned to the order of attributes in the writer feature type. 

 

 

If you wish to order the attributes in a writer feature type alphabetically quickly, you can either go to Writers-> Import Feature Type and import an existing alphabetically sorted feature type.

 

 

Note that is recommended to hide or unexpose attributes that are not needed by transformers in the workflow as such reduces clutter. Unexposed attributes can still be written out. To unexpose an attribute, go to the reader feature type and go to the User Attributes tab.

Forum|alt.badge.img
  • June 2, 2014
If you are just talking about the sorting of attributes under a transformer in FME 2014 SP1 (i.e. the GUI function), then yes, it doesn't work. We raised a bug a few months ago. It hasn't been fixed at SP2, so hopefully sometime in the next couple of releases