Discussion Board for collaboration on QlikView Scripting.
I have been task with loading data from an existing file structure into to QV which is causing me a few headaches.
ODBC CONNECT TO [Property Valutions;DBQ=W:\Property Statistics\Valuers Templates\2011\June 2011\KF\*.xlsb];
LOAD `BL Prop Ref`,
`Final Reversionary Yield`,
`Landmark Previous Valuation`,
SQL SELECT `BL Prop Ref`,
FROM `W:\Property Statistics\Valuers Templates\2011\June 2011\KF\*.xlsb`.`_FilterDatabase`;
Level 1 - Year (eg 2008,2009,2010, 2011 etc)
Level 2 - Valuation Quater (March 2011, June 2011, Sept 2011)
Level 3 - Comany (Comapny 1, compnay 2, Company 3 etc)
See attached folder structure
Unfortuneatly I have no control over the file type, structure, or folder structure so need to get QV to load this data in its current format.
Your help would be most appreciated.