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;
