I'd like to be able to use a calculated value (max(myfield)) in a reader where clause i.e. where myfield2 > max(myfield). Is there a way to do this, or is there a better transformer/workflow to use?
You can do this by attaching a FeatureReader (instead of the reader) to the SQLCreator transformer.
The FeatureReader is a transformer that acts like a reader, but with the option to pre-process the initiator.
The documentation for the FeatureReader is here
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.