Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team,
I have a table which has huge amount of data, which does not have a primary key. What I was doing earlier is I will truncate and load data whenever needed so that I can get latest data. One reason being the table size is huge and loading this takes significant time. I have identified a column which can be used as a filter column.
For eg: I have ran the task today(02-08-2024) and Im loading the table again on (10-08-2024). I can use that column and I can filter it using the column identified, and get records which are newer. I want to know how can I use the same logic using Qlik Replicates "Record Selection Condition"
Regards,
Sreehari
Hello Team,
Good Day and thanks for reaching Qlik Community.
You can use the passthrough filter to filter out the required data from the source DB during full load. Please find the below article which might help you!!
Filter for last 90 days of data in Qlik Replicate - Qlik Community - 1880761
Regards,
shivananda
Hello Team,
Good Day and thanks for reaching Qlik Community.
You can use the passthrough filter to filter out the required data from the source DB during full load. Please find the below article which might help you!!
Filter for last 90 days of data in Qlik Replicate - Qlik Community - 1880761
Regards,
shivananda
Thank you @kng