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

[unay]

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

[OritA]

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

[Dana_Baldwin]

Hi @unay 

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

Dana

[john_wang]

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.

[unay]

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

[VXS1031]

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