topic Can i make it Apply/store changes when: File size reaches(KB): as zero? in Qlik Replicate

Can i make it Apply/store changes when: File size reaches(KB): as zero?

TTH1 — Wed, 21 Jun 2023 16:40:08 GMT

Hi All,

Target endpoint is Microsoft Azure ADLS hence while creating file for every one hour shall I make it zero to

Apply/store changes when: File size reaches as zero

Apply/store changes when: Elapsed time reaches :3600 sec is that correct approach?

Please help

Re: Can i make it Apply/store changes when: File size reaches(KB): as zero?

Heinvandenheuvel — Wed, 21 Jun 2023 20:21:09 GMT

>>> Apply/store changes when: File size reaches as zero

WHY? I'm guessing you want the size 0 to be interpreted as UNlimited? But WHY? To make it 'nicely' come every hour on the hour? Please clarify the BUSINESS REQUIREMENT you are trying to achieve.

HOW? The UI clearly indicated the minimum is 1, and attempting to set it 0 in the UI will make it 'jump' back to 1. Did you try? Or did you change it in the JSON? Sure you can change the JSON but it may well internally 'jump' back to 1 and you'd be in unsupported territory - is the business ok with that? It's a free country though - go ahead try!

File size reaches(KB): (1 - 1,000,000,000)

So the max is 1Terabyte. That's a big file which would take long to transfer and apply. Let's assume full 10 Gb network transfer. If my math is right than that would take approx 1000 seconds before the work even starts. How long to apply? My guess is longer than an hour and your goal? wish? requirement? of hourly apply would not hold.

Just pick 1,000,000,000,000 (1000 GB) if you feel the need, but I suspect the whole solution will work better with a 10GB file limit.

Good luck,

Hein

Re: Can i make it Apply/store changes when: File size reaches(KB): as zero?

Dana_Baldwin — Wed, 28 Jun 2023 21:34:30 GMT

Hi @TTH1

If one of the replies helped to resolve the issue, please mark it as a solution & like it to make it easier for others to find.
Thanks in advance!