topic Re: Doing full load with date condition in Qlik Replicate

Doing full load with date condition

gseckin — Fri, 13 Jun 2025 08:58:01 GMT

Hi,

We use oracle and we'd like load spesific date and condition, but it seems it load more than the filter we passed. Is this a correct date format to filter table by datetime(0) column? Thanks

Re: Doing full load with date condition

john_wang — Fri, 13 Jun 2025 09:02:12 GMT

Hello @gseckin ,

Could you please clarify which phase you're referring to — the Full Load (initial load) phase or the Change Processing (CDC) phase? Both phases offer a variety of options that can be tailored to your needs. If you can share more details about your scenario, we’d be happy to provide more specific and accurate suggestions.

Regards,

john.

Re: Doing full load with date condition

gseckin — Fri, 13 Jun 2025 09:04:40 GMT

hi,
Full load phase, we want to do full load with two filter vaulues. the first one is int4 and second one is datetime(0) and datetime should be between this time 2025-06-03 13:00, 2025-06-03 15:00 .

Re: Doing full load with date condition

john_wang — Fri, 13 Jun 2025 09:14:54 GMT

Hello @gseckin ,

Please check the sample in article: filter on a date dataype column

Take note it takes action for Full Load phase only.

Hope it helps.

John.

Re: Doing full load with date condition

gseckin — Fri, 13 Jun 2025 09:18:47 GMT

We just have these box, I don't see full load pasthou section.

Can I do here?

Re: Doing full load with date condition

john_wang — Fri, 13 Jun 2025 09:23:30 GMT

Hello @gseckin ,

Please follow the steps here.

Regards,

John.