Multiple RPL table after applying global rules into Qlik replicate

[Tool_Tip]

Dear members,

We have created the LOG STREAM folder [LSCAPSDWH] on the replicate server and set up the corresponding task in the replicate console. For example, we previously saved data from the table BLS.BL_PARTY_CONT into the logstream LSCAPSDWH as shown below:

We have now set up a new replicate task, where our source is the logstream tables. This task saves the same table into the target under RPL_schema, applying global rules to append the suffix "WITH_DUPLICATES" to the table name.

After successfully running the task, we observed that two tables were created under the RPL Schema on the target:

1. RPL.BL_PARTY_CONT — Empty table

2. RPL.BL_PARTY_CONT_WITH_DUPLICATES — Table with data

We would like to understand why two tables are being created when we are only applying a suffix operation. Additionally, if one table is empty and the other contains data, the empty table seems unnecessary.

Could you please let us know if we are missing something that would allow us to create just a single table with the suffix and data?

Thank you.

[john_wang]

Hello @Tool_Tip ,

Looks to me the table RPL.BL_PARTY_CONT_CT should be RPL.BL_PARTY_CONT_WITH_DUPLICATES_CT too. is that correct? 

However we need additional information to confirm the behavior. Please open a support ticket with SOURCE_UNLOAD/TARGET_LOAD/TARGET_APPLY set to Verbose (please decrypt the verbose log files).  Our support team will be more than happy to assist you.

Regards,

John.