How to reload Single table in Qlik Compose without a drop and recreate

Nanda_Ravindra — Wed, 21 Jun 2023 13:58:01 GMT

The information in this article is provided as-is and to be used at your discretion. So, please implement and test this in the testing environment before applying this to production.

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

On Replicate Server: Stop the task for the table in question
On the Qlik Compose server:
1. Run the CDC task for the table in question (this will get any current __ct records processed)
2. Under ‘Manage task’, duplicate the Full load task for the table in question
  
  Note: Make sure to select the ‘Full load Only’ option under the task type
3. Enable the ‘handle duplicate’ check box for the newly created task that you created by duplicating the Full load task in Step#2B
4. Generate instructions for the newly created task.
On the Qlik Replicate server:
1. Reload the table in question and start the task
On the Qlik Compose server:
1. Run the newly created Full load task <-- This is a one-time activity.
2. Verify the data.
3. Remove the newly created Full load task.
4. Resume the CDC task.

Environment

all versions
Data Warehouse 7.x

article How to reload Single table in Qlik Compose without a drop and recreate in Official Support Articles

How to reload Single table in Qlik Compose without a drop and recreate

Environment