BUFFER

[fmazzarelli]

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;