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
  • 6 views
J

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?

1 reply

erik_jan
Contributor
Forum|alt.badge.img+18
  • erik_janContributor
  • 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

Reply


Helpful Members This Week

Community Stats

31,504
Posts
119,429
Replies
39,125
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.