Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

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

Thanks, Yes you right we can use both.

Regards

Anand

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