topic Re: Custom SQL joining five tables based on a transaction id and applying filter in Qlik Replicate

Custom SQL joining five tables based on a transaction id and applying filter

unay — Tue, 18 Feb 2025 15:37:13 GMT

Hello,

We are currently using May 2024 version.

One of my clients is using five tables in Qlik Replicate in a CDC task and they would like to apply filter on one table and join the rest of the four tables using a transaction ID that is present across all the tables..

Does Qlik Replicate offer a feature to write a custom SQL joining these tables and applying a filter at the table selection level /using pass thru filter in the designer tab.

Please suggest.

Thank you,

Pranathi

Re: Custom SQL joining five tables based on a transaction id and applying filter

OritA — Thu, 20 Feb 2025 09:04:46 GMT

Hi Pranathi,

Currently Replicate does not provide the option to join tables trhough a filter. If you wish you can open an ideation request so our PM can consider adding this functionality to the product.

regards,

Orit

Re: Custom SQL joining five tables based on a transaction id and applying filter

Dana_Baldwin — Thu, 20 Feb 2025 16:08:08 GMT

Hi @unay

Here is the link to submit a feature request: https://community.qlik.com/t5/Ideas/idb-p/qlik-ideas

Dana

Re: Custom SQL joining five tables based on a transaction id and applying filter

john_wang — Fri, 21 Feb 2025 09:40:33 GMT

Hello Pranathi, @unay

Additional to @OritA and @Dana_Baldwin comments:

If you are referring to a Full Load only task, you can create a view in the source database using a custom SQL query that joins the required tables and applies the necessary filters. Then, replicate the view to target side DB.
If you need both Full Load and CDC functionality, a view will not work. Instead, you must first replicate the base tables to the target and then perform the join there. Or a Feature Request needed.

Hope this helps.

John.

Re: Custom SQL joining five tables based on a transaction id and applying filter

unay — Wed, 12 Mar 2025 15:22:13 GMT

Hello,

One of our clients has a question - they would like to have a query for a single table

ACCT_ID IN (
SELECT DISTINCT ACCT_ID FROM <schema_name.table_name> WHERE <column_name> NOT IN ("xxxxxxxx") LIMIT 30).

Can they have this query built in expression builder in the Replicate.

Thank you,

Pranathi

Re: Custom SQL joining five tables based on a transaction id and applying filter

VXS1031 — Thu, 13 Mar 2025 13:22:17 GMT

Hi Pranathi,

If it the full-load only task you can use the pass thru filter for the same where you can write the custom sql query that will be running against the source.

You can access that option by holding the control key and open the table, then navigate to filter section. you can find the passthru filter at bottom.

Thanks,

Surya