Question

Transformer won't sort attributes


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.

 

 


2 replies

Badge +2
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.
Badge
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

 

Reply