Skip to main content
  • EN

Hi, wondering if anyone know how to limit the featurereader, I am trying to read only the first 10 rows from each table in postgres and it is still pulling back every row before passing on only 10. What am I doing wrong?

 

Thank you in advancerecord limit

Hi @oliver.morris​, it's a bit odd that FME is not respecting these settings. I just tested this myself and these settings limit the reader to only reading in 10 features overall, not 10 features from each table. In this situation I would recommend using the SQLCreator transformer to run a SQL query on the data, bringing in only the first 10 rows. This thread on stackoverflow has some great ideas on how to go about this. This page on W3S provides more information on the syntax.

thanks @danminneyatsaf​ 

Reply


Community Stats

30,176
Posts
114,541
Replies
37,835
Members
Terms & ConditionsCookie 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.