Skip to main content
Solved

Grab first 1000 records

  • February 15, 2017
  • 3 replies
  • 204 views

I am using Sampler to grab fisrt 1000 records but it reads all 2 million records that I am dealing with before grabbing first 1000 values. How do I avaoid it? Thanks.

Best answer by jeroenstiers

Hi @anaresh299

You can specify the number to read in the Navigator window.

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.

3 replies

Forum|alt.badge.img+7
  • Best Answer
  • February 15, 2017

Hi @anaresh299

You can specify the number to read in the Navigator window.


  • Author
  • February 15, 2017

Hi @anaresh299

You can specify the number to read in the Navigator window.

@jeroenstiers It worked. Thanks.


Forum|alt.badge.img

Or if you use a SQLCreator/SQLExecutor you can simply put limit on the query (PostgreSQL).

capture.png