Table removed from table selection still in Target

[xiniavargas]

We mistakenly added a table in our table selection, we stopped the task, removed the table and started the task again, Qlik shows less tables being replicated, but the deleted table from the table selection is still in our target. We were expecting it to be removed from target even it wasn't deleted from our source, but only from the table selection. Do we have to manually delete the table from our target? or there is a setting we can't find?

[Michael_Litz]

Hi @xiniavargas 

Yes, you will need to remove the target table manually.

Thanks,
Michael

[xiniavargas]

thanks for clarifying, not what we were expecting.

[deepaksahirwar]

Dear @xiniavargas ,

Thank you for reaching out to us in the Qlik Community.

To remove a table from the replication task, you need to select the table from the Selected Tables list and click the Remove button. Then you need to click OK and Save to apply the changes.

But it  does not delete the table from the target. It only stops replicating the table from the source. If you want to delete the table from the target, you need to do it some manual configuration from the task settings and select drop option.(Explore Task Settings in qlik replicate)

However, there are some settings in Qlik Replicate that allow you to control how to handle the target table for the change capture. For example, you can choose to drop, truncate, alter, or ignore the target table when the source table is dropped, truncated, altered, or renamed.

You can also use the Transform tab to modify the structure and content of the target tables, such as adding, dropping, or renaming columns, or defining expressions.

There is no setting in Qlik Replicate that automatically deletes the table from the target when you remove it from the replication task.

I hope this helps you.😊

If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer.

Regards,

Deepak 

[john_wang · Accepted solution]

Hello @xiniavargas ,

In cases where Qlik Replicate does not monitor all tables in the source and target databases, there's no necessity to drop these unmonitored tables. This is by-design in Qlik Replicate. Even if Qlik Replicate creates a target table, it might still be utilized by other tasks or apps. Manual dropping is only required if the table is no longer needed. 

Hope this helps,

John.

[xiniavargas]

oh, that makes sense! thanks for clarifying