topic Qlik Replicate: Setting up Filter using SQL lite expression in Qlik Replicate

Qlik Replicate: Setting up Filter using SQL lite expression

dineshkumarl — Wed, 27 Dec 2023 10:02:01 GMT

Hi All,

I am trying to load Today-1 data for a table from Oracle.

Option1:

Using data and time function filter in Qlik Replicate

1. Click on the table

2. Navigate to Filter > click on Expression Builder

3. $columnname=date('now', '-1 days')

I do get the resulted date as previous date when I test the expression.

However, when I run the task, I do not see any data flow. I kept the task running for 10mins, 30mins, 1hour and 2hours period but didn't observe any data flow.

Option 2:

Defining the above function in Transform

1. click on the tale

2. Navigate to Transform option

3. Select the date column where we want to apply the filter and click on 'fx' option

4. In expression builder type date('now', '-1 days') and test it

5. Able to get previous date as result.

I do observe data flow but the filter condition doesn't work. I say data from other days as well rather than for the previous date.

Kindly let me know where I am going wrong in this. Appreciate any assistance towards the same.

Thanks

Re: Qlik Replicate: Setting up Filter using SQL lite expression

john_wang — Wed, 27 Dec 2023 10:16:35 GMT

Hello @dineshkumarl ,

Thanks for reaching out to Qlik Community.

Please check the sample full load pass thru filter, in the sample it's 90 days, hope it helps.

Regards,

John.

Re: Qlik Replicate: Setting up Filter using SQL lite expression

dineshkumarl — Thu, 28 Dec 2023 03:31:43 GMT

Thank you for the update. The full load pass through filter works.
We would have to specific the condition as per source DB. For oracle I have specified trunc(SYSDATE)-1.

It works as expected.

Cheers!

Re: Qlik Replicate: Setting up Filter using SQL lite expression

john_wang — Wed, 27 Dec 2023 14:54:22 GMT

Thank you so much for the feedback @dineshkumarl !