Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am in the process of converting an application that uses q QVD from Qlik view to Qlik Sense. I have this in my script currently to load the data into a QVD file:
Directory 'F:\WaitTimes';
For each ExcelFile in filelist ('*.xlsx')
WaitTimesData:
BUFFER (incremental) Load * From $(ExcelFile) (ooxml, embedded labels, table is [WaitTimes]);
Next ExcelFile;
STORE WaitTimesData INTO [F:\DataAgg\WaitTimesAggregate.qvd] (qvd);
How can I go about converting correctly?
Just create a folder connection to the F drive and load using LIB created