Filter not working in sheet?

Questions
,
1

So I am importing a table from google sheets and I want to filter the results for when the “Previsão” value it’s higher than the “Limite” however the filter is outputting me all the data anyway. Also I supose that if I checked the “Execute Once” it would output me just the first row higher than the “Limite” however when I enable this I don’t get an output at all :confused:

image
image1777×741 42.9 KB

Information on your n8n setup

  • **n8n version:Latest
  • **Database (default: SQLite):Sheets
  • **n8n EXECUTIONS_PROCESS setting (default: own, main):Default
  • **Running n8n via (Docker, npm, n8n cloud, desktop app):Docker
  • **Operating system:Windows
2

Ok I fixed the number of outputs but I still have the issue of not being able to use the Execute Once to get only first result.

3

Found a solution, with Limit nodes :+1:

1 Like
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.