Solved

Feature Reader not respecting max features to read

  • 27 October 2021
  • 2 replies
  • 18 views

Badge +10

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

icon

Best answer by danminneyatsaf 1 November 2021, 19:43

View original

2 replies

Userlevel 2
Badge +9

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.

Badge +10

thanks @danminneyatsaf​ 

Reply