Can Qlik Replicate Filters Use Values from Environment Variables or External Files?

[gideeeh]

I'm exploring options in Qlik Replicate to apply a filter based on a dynamically changing value. Specifically, I want to use an external source (like a parameter file) to supply a value for filtering a table, so the filter criteria would change automatically with each run based on the latest value in that file.

I haven’t found any options in the filter settings to support reading directly from an external file or parameter source. As a potential workaround, I’m considering the use of locally defined environment variables to pass this dynamic value as a filter.

Questions:

1. Is it possible to use environment variables in Qlik Replicate’s filter settings, and if so, how?
2. Alternatively, is there any supported way to pull filter values from an external file or parameter source in Qlik Replicate?

Any guidance on how to implement dynamic filtering in this context would be greatly appreciated!

[john_wang]

Hello @gideeeh ,

Welcome to Qlik Community forum and thanks for reaching out here!

Transferring dynamic input values into a Qlik Replicate filter condition expression can be challenging. However, there are a few approaches that can help:

1. Using User-Defined Transformations: You can utilize locally defined environment variables to pass dynamic values as filters through user-defined transformations. A sample C program, "MyTransformation," is available by default in the directory: C:\Program Files\Attunity\Replicate\addons\samples\MyTransformation. Note that Qlik Replicate currently supports C language programming for such transformations.

2. Using a Secondary Source Table: Another method is to leverage an additional table within the same source database to combine the required tables. Before running the task, update this parameter table with the necessary input values to ensure the filter condition reflects the latest information.

Hope this helps.

John.