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.
Page 1 / 1
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 :-)