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

[Shaira]

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!

[john_wang]

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.

[Shaira]

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!

[john_wang]

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.