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.
Solved
How to pass Excel attributes to a SQL Creator?
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.
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.
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.
