Skip to main content
  • EN

I am not getting the results that I expected. I believe it may be because I do not have anything connected to the 'Initiator' for the SQLExecutor transformer. What I was trying to do, was to execute the SQL statement and if no results were returned then proceed with the workspace. If records are returned, then send to the Writer. This sql statement should return 1 row.

You can just put a creator in front of your sqlexecutor, this will then execute the sql statement once, using your referenced parameter

You can just put a creator in front of your sqlexecutor, this will then execute the sql statement once, using your referenced parameter

Thanks, that did it.

Reply


Community Stats

30,176
Posts
114,544
Replies
37,837
Members
Terms & ConditionsCookie 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.