Qlik Community

QlikView Documents

Documents for QlikView related information.

Create the txt file when no record load in Table

Create the txt file when no record load in Table

I provide this simple script for the QVD log creation when there is no records loaded


Tab:

LOAD * Inline

[

Name

];

LET vNoOfRow = NoOfRows('Tab');

If $(vNoOfRow) = 0 Then

Status:

LOAD

'No Data Received on '&Now() as Status

AutoGenerate 1;

STORE Status into Status.txt(txt);

ENDIF;


By this we get the QVD status that the file is not having the No data on particular folder location also


And if you try to load it with some data then the status Qvd not loaded.

Tags (2)
Comments
eugenyilyin
Contributor II

Hi

If 0 = 0 Then ...

Do you think this is true?

Use If vNoOfRow = 0 instead of  If $(vNoOfRow) = 0

0 Likes

Thanks, Yes you right we can use both.

Regards

Anand

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2014-11-26 06:46 AM
Updated by: