Skip to main content
Question

Is there a way to use a calculated value from a SQLcreator in a reader

  • April 25, 2019
  • 1 reply
  • 10 views

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?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

erik_jan
Contributor
Forum|alt.badge.img+22
  • Contributor
  • April 25, 2019

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