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?
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.
Opens in new window
PDF Download
Word Download
Excel Download
PowerPoint Download
Document Download
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
