Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fmazzarelli
Contributor III

BUFFER

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;