Skip to main content
Archived

Add prefix initiator to SQLExecutor.

Related products:Transformers
  • March 20, 2018
  • 1 reply
  • 9 views
siennaatsafe
fmelizard
redgeographics
itay
egge
+13
  • siennaatsafe
    siennaatsafe
  • fmelizard
    fmelizard
  • redgeographics
    redgeographics
  • itay
    itay
  • egge
    egge
  • martinkoch
    martinkoch
  • cwarren
    cwarren
  • patrick_koning
    patrick_koning
  • ivodeliefde
  • g_karssenberg
    g_karssenberg
  • kweller
    kweller
  • troelspe
  • ffichtner
  • hondius
  • patricko
  • lvdburgt
  • samuelvaldez
  • mark2atsafe
    mark2atsafe

nielsgerrits
VIP

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.

<strong>This post is closed to further activity.</strong><br /> It may be a question with a best answer, an implemented idea, or just a post needing no comment.<br /> If you have a follow-up or related question, please <a href="https://community.safe.com/topic/new">post a new question or idea</a>.<br /> 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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings