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

[Nanda_Ravindra]

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.

1. On Replicate Server: Stop the task for the table in question
   
   
2. 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.
      
      
3. On the Qlik Replicate server:
   
   
   1. Reload the table in question and start the task
      
             
      
      
4. 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

Qlik Compose all versions
Qlik Compose for Data Warehouses Data Warehouse 7.x