Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Qlik Replicate and how to dynamically add all tables in a specific schema?

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Melissa_Potvin
Community Manager
Community Manager

Qlik Replicate and how to dynamically add all tables in a specific schema?

Last Update:

Feb 2, 2022 6:22:54 AM

Updated By:

Sonja_Bauernfeind

Created date:

Mar 26, 2020 11:34:50 AM

Qlik Replicate allows the user to include a dynamic table selection. This is done using a pattern as follows:

Schema Pattern Result
HR % All tables in the HR Schema.
This will include any newly added table.
HR JOB% All tables starting with JOB, for example:
  • JOB_HISTORY
  • JOBS
HR %HISTORY% All tables starting with JOB, for example:
  • JOB_HISTORY
  • JOB_HISTORY_ACTIVE

 

After specifying the schema and pattern click on Include

servlet (1).png

 

 

 

 

 

After clicking on the pattern, it will be added to the "Table Selection Pattern" with the prefix "Include":

servlet (2).png

 

 

Tags (1)
Labels (1)
Version history
Last update:
‎2022-02-02 06:22 AM
Updated by: