Discussion Board for collaboration on QlikView Scripting.
I am new to Qlikview. I wanted to share the below sub routine that I wrote with the community.
vQVDFileName - Full path to the QVD file from which you have to load / store data.
vTableName - Table name into which you load the data.
vXLSFileName - Full path to the excel file from where data will be loaded for the first time.
vXLSAppendFileName - Full path to the excel file from where incremental data will be loaded. i.e. Every week data needs to be appended to the DB.
The if else structure in the sub routine was based on my specific needs / my ignorance. But I believe that the overall technique is right.
Source code (Feel free to use):
SUB DataLoad (vQVDFileName, vTableName, vXLSFileName, vXLSAppendFileName)
if isnull(FileTime(vQVDFileName)) Then
(ooxml, embedded labels);
Store $(vTableName) into $(vQVDFileName);
ELSEIF (not IsNull(FileTime(vXLSAppendFileName))) Then