topic Re: Global Filter in Qlik Replicate

Global Filter

pnvsriram — Fri, 15 Nov 2024 22:30:55 GMT

Hi All,

I need to filter the data from the source and it is the same column and the same filter for all tables in a Task. is there a way to create a global filter like the global transformation?

Re: Global Filter

john_wang — Mon, 25 Oct 2021 01:06:42 GMT

Hello @pnvsriram ,

Yes, it's easy. You can use Global Filter to achieve that. Global Filter is supported from Replicate version 2021.5. If you are running lower versions eg 6.6/7.0 then you need upgrade to version 2021.5.

I'm pasting my demo, it filters rows based on the common column "ID" (in the filter expression you use "$ID") which appears in all tables, if the value of "ID" is larger than 2 then the rows will be replicated to target side, otherwise will be ignored. It take actions for both Full Load and CDC.

Hope this helps.

Regards,

John.

Steps to create the global filter:

Re: Global Filter

pnvsriram — Mon, 25 Oct 2021 01:12:59 GMT

Hi @john_wang

thank you so much, you're right I'm on an older version and using the tool from the AWS market place and I have to find a way to upgrade to the latest version.