+2I have a workspace that sends data to a url through the HTTP Caller transformer. I want to terminate the workspace if a NULL value exists in a field that is in a table on a SQL database before the data is sent. What is the best way to do this? Do I still need the Creator transformer if I use a Tester?
Best answer by liamfez
You could use a Terminator after a Tester (testing for a NULL). Yes, you would still need a Creator to start things off in that case.
+44You could use a Terminator after a Tester (testing for a NULL). Yes, you would still need a Creator to start things off in that case.
+2Thanks
+44Thanks
Assuming you have the Tester set up so that features that are not NULL are Passed, then yes. If a NULL feature exits the Failed port, it will then terminate translation. You can add custom messages in the Terminator to provide more information, like a short message detailing why translation was terminated, which will go to the log.
I initially misunderstood your question about the Creator. How you have that screenshot you then do not need the Creator. The reader will provide the features.
