How to Limit Output Rows in Qlik Replicate

Shaira — Fri, 25 Apr 2025 05:02:02 GMT

Hi,

We’re looking to limit the number of rows extracted during a Qlik Replicate. For testing, we want to output only a thousand rows from our dataset. We tried using the Pass Thru filter and added row-limiting logic like LIMIT or TOP but it still doesn't seem to work and results in errors.

We'd like to clarify on whether Qlik Replicate supports row-limiting features. If not, what are the recommended approaches to achieve this for testing?

Thanks!

Re: How to Limit Output Rows in Qlik Replicate

john_wang — Fri, 25 Apr 2025 06:08:48 GMT

Hello @Shaira ,

I’m assuming you're referring to a Full Load ONLY task. If Change Processing is enabled, simply limiting the number of rows is not recommended. This is because changes on the source system (e.g., INSERT, UPDATE, DELETE) will still be captured and applied to the target. If some rows were discarded during the previous capture (e.g., an INSERT with PK = 1000), and a subsequent DML like an UPDATE on PK = 1000 is captured, it would result in a "row not found" error on the target.

If you're planning to use row-limiting logic such as LIMIT or TOP, the exact syntax depends on the source database type, as the SQL is executed directly on the source system.

Could you please confirm it's a Full Load ONLY task? if yes, share the source database type and the specific error you’re encountering? We’d be happy to help further.

Regards,

John.

topic How to Limit Output Rows in Qlik Replicate in Qlik Replicate

How to Limit Output Rows in Qlik Replicate

Re: How to Limit Output Rows in Qlik Replicate