0 Replies Latest reply: Nov 3, 2015 9:33 AM by Fabio Mazzarelli RSS

    BUFFER

    Fabio Mazzarelli

      Hi Community,

       

      I copied this script and changed the path

       

      But when I debug the variable FileName, i notice that it's c:\users.qvd insted of C:\QLIK SENSE SAMPLE DATA\data sources\qvd\

       

      What escapes me?


       

      LET Last_Updated = today();

      FOR EACH FileName in filelist('C:\QLIK SENSE SAMPLE DATA\data sources\qvd\*.qvd')

        QVDStatus:

        LOAD

        '$(Last_Updated)' as QVD_last_updated,

        Date( QvdCreateTime('$(FileName)') ,'YYYY-MM-DD hh:mm:ss') as FileTimeStamp,

        QvdNoOfRecords('$(FileName)') as QVD_record_count,

        QvdTableName('$(FileName)') as QVD_table

        AUTOGENERATE 1;

      NEXT;