topic Creating the output file and .dfm (metadata) file when Filtering Records Returns Zero (0) Results in Qlik Replicate

Creating the output file and .dfm (metadata) file when Filtering Records Returns Zero (0) Results

Shaira — Mon, 31 Mar 2025 08:45:50 GMT

Hi Support team,

Is there a way to create both an empty output file and a .dfm file (metadata settings checked) when the filtered records return zero (0) results. This is a necessary step for our solution, and your response is highly appreciated.

Thanks!

Re: Creating the output file and .dfm (metadata) file when Filtering Records Returns Zero (0) Results

john_wang — Mon, 31 Mar 2025 09:38:20 GMT

Hello @Shaira ,

Thanks for reaching out to Qlik Community!

Personally I do not think the empty data file and .dfm file will be generated in current major versions.

If this is a feature you would like to see, please submit a request here which goes to our Product Management team. Other users will have the opportunity to vote on it to increase the chances at adoption and to set the priority: https://community.qlik.com/t5/Ideation/ct-p/qlik-product-insight.

Hope this helps.

John.

Re: Creating the output file and .dfm (metadata) file when Filtering Records Returns Zero (0) Results

Shaira — Thu, 03 Apr 2025 07:14:15 GMT

Hi John, thanks for your response!

Since Qlik Replicate cannot generate an empty data file or a .dfm file when the returned records are 0, can you suggest a method to at least have an indicator in the Qlik Replicate target folder to signify that no records were loaded?

Thanks!

Re: Creating the output file and .dfm (metadata) file when Filtering Records Returns Zero (0) Results

john_wang — Thu, 03 Apr 2025 07:18:57 GMT

Hi @Shaira ,

Please check the task log file, in general we will get below info:

00030464: 2025-03-31T17:19:58 [SOURCE_UNLOAD ]I: Unload finished for table 'SCOTT'.'KIT' (Id = 1). 0 rows sent. (streamcomponent.c:3805)
00024396: 2025-03-31T17:19:58 [TARGET_LOAD ]I: Load finished for table 'SCOTT'.'KIT' (Id = 1). 0 rows received. 0 rows skipped. Volume transferred 0. (streamcomponent.c:4089)
00036860: 2025-03-31T17:19:58 [TASK_MANAGER ]I: Loading finished for table 'SCOTT'.'KIT' (Id = 1) by subtask 1. 0 records transferred. (replicationtask.c:3154)

Hopt it helps.

John.