Skip to main content
Archived

Add prefix initiator to SQLExecutor.

Related products:Transformers
  • March 20, 2018
  • 1 reply
  • 33 views
nielsgerrits
VIP
Forum|alt.badge.img+66

When reading data with the FeatureReader I often merge attributes as this is a more efficient alternative for using the FeatureMerger afterwards.

In the FeatureReader you can choose for Prefix Initiator to prevent overwriting conflicting attributes. This is not added (yet) to the SQLExecutor. Would be nice addition.

Current workaround is to use a BulkAttributeRenamer before the SQLExecutor.

Buckle your seatbelt Dorothy, cause Kansas is going bye-bye...
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.

1 reply

danielkroon
Forum|alt.badge.img

I would like to see that too. But, I also want the option to prefix all attributes created by the query. Not only the initiator attributes. Example "SELECT a,b,c FROM alphabet" resulting in following FME attributes with prefix: prefix_a, prefix_b, prefix_c

 

It would also be nice to have the ability to do a case change, as you can do in the BulkAttributeRenamer.

Community Stats

32,751
Posts
124,208
Replies
41,263
Members
Terms & ConditionsAccessibility 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.