Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How can I limit the amount of processed rows in a job?

I know that I can limit the amount of incoming data from the database using LIMIT in the SQL query, but I was thinking if there is a way to set a limit on the amount of successfully processed rows that the job completes?
Labels (2)
2 Replies
Anonymous
Not applicable
Author

Hi
Try the tSampleRow component which can be used to choose a list of line numbers.
Best regards
Shong
Anonymous
Not applicable
Author

Hi there, 
I am integrating MSSQL to Salesforce. How can I limit the Number of rows to 10 in place of running for a million or so records