How to create blank table if there is no delta on that particular time frame

[TTH1]

Hi All,

Is there any option in qlik replicate if there is no delta records for that particular time slot, will it produce blank file option 

Thank you

[john_wang]

Hello @TTH1 ,

Thanks for reaching out!

That depends, not sure which target endpoint you are using. However You may manually let Replicate to create the metadata (without any data transfer), see Advanced Run Options --> Create missing tables and then stop:

Hope this helps.

Regards,

John.

[SwathiPulagam]

Hi @TTH1 ,

Did John's suggestion work?

If it did not work, please inform us of your target endpoint.

Thanks,

Swathi

[TTH1]

I am not getting that option can you please help me. My target end point ADLS(Azure Data Lake Storage).

[john_wang]

Hello @TTH1 ,

You may get there from "Advanced Run Options":

then you can see the option in the next windows:

Be careful especially while you are using the option "Recreate all tables and then stop" option, because this step may drop your target table.

Good luck,

John.

[Heinvandenheuvel]

Hmm, I saw your later question  ( https://community.qlik.com/t5/Qlik-Replicate/Can-i-make-it-Apply-store-changes-when-File-size-reache... ) is that related?

What are you you really trying to achieve? What is the end-goal here?

One guess is that you'd like to show some sign of activity, of being alive, every hour or so whether there are changes or not. 

I would recommend an additional non-production table for that with a procedure/script/job running on the source to put a row in the helper ( tickler? watchdog? ) table with a little bonus information. Just a sequence number and timestamp, but potentially also some 'interesting' data which happens to be available. Maybe DB load %, Connection count, anything useful to help analyze (performance) problems and behaviors in some future. In the Replicate task add the task name, server, and replicate local processing date/time, such that you have a record of delays (if any).

Regards,

Hein.

[Dana_Baldwin]

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!