Skip to main content
Solved

How to pass Excel attributes to a SQL Creator?

L
Forum|alt.badge.img

I have an Excel spreadsheet where I want to pass several attributes as variables into a SQL Query using a SQL Creator transformer. What is the best way to achieve this? I don't see how I can make the attributes as user parameters.

Best answer by takashi

Why not use the SQLExecutor rather than SQLCreator? You can read the Excel attributes with an Excel reader then use the feature attributes to build a SQL statement in the SQLExecutor.

View original
Did this help you find an answer to your question?

2 replies

takashi
Evangelist
  • takashiEvangelist
  • Best Answer
  • May 14, 2019

Why not use the SQLExecutor rather than SQLCreator? You can read the Excel attributes with an Excel reader then use the feature attributes to build a SQL statement in the SQLExecutor.

L
Forum|alt.badge.img

That's it! Thanks Takashi. I knew it could be done :-)

Reply


Helpful Members This Week

Community Stats

31,479
Posts
119,348
Replies
39,100
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

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
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.