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.