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?
Page 1 / 1
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