Table Selection in a Task

[vinayak_m]

Hi Team,

If I have a task with 30 tables which are selected, is there any way to mark them inactive or deselect them without creating a new task or modifying my current task(to delete the non essential tables).

As far as I have searched, I was not able to find out anything. Is there a workaround for such situations?

Thanks in advance!  

[john_wang · Accepted solution]

Hello @vinayak_m ,

Thanks for reaching out to Qlik Community!

No option to mark some tables inactive or deselected in a running task. We need to edit the task:

1. Stop the running task.

2. Edit the task to remove some tables.

   • Save the changes.
   • Resume the task. (These tables will be excluded from the replication queue.)

3. Edit the task to add these tables back or add more tables.

   • Save the changes.
   • Resume the task. (These tables will be added to the replication queue. Qlik Replicate will perform a Full Load on these tables first. After the Full Load, the CDC stage will start automatically.)

Hope this helps.

John.

[Heinvandenheuvel]

If you think you might have to re-enable the tables at a later stage, then you might want to rename the explicitly selected source tables to X_<table> or  DISABLED_<table> or some such to retain the fact that it was previously selected. The now non-existing tables will have no negative effect on the task when resumed because Replicate always ignores non-existing source tables.

Hein