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
View original
+17
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.
That's it! Thanks Takashi. I knew it could be done :-)
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
