Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
vinayak_m
Contributor III
Contributor III

Table Selection in a Task

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!  

1 Solution

Accepted Solutions
john_wang
Support
Support

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!

View solution in original post

2 Replies
john_wang
Support
Support

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
Heinvandenheuvel
Specialist III
Specialist III

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