Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a spreadsheet with the tab names as the date of the monthly data. How do I set the month for each table in the script when I load the files? So May 2010, June 2010, July 2010 tabs are loaded individually and in the load statement, when I input "Set date" or "set month" or Set May" I get an error statement. I hope that makes sense.
If I understand correctly for each Excel, do the following:
Load makedate(2010,5,1) as Date,
... // Other columns
From x.xls (... May$);
Regards.
If I understand correctly for each Excel, do the following:
Load makedate(2010,5,1) as Date,
... // Other columns
From x.xls (... May$);
Regards.
Thanks, that takes care of the date, but now how do I set the year so that when I begin to add data next year I can compare the monthly results?
For a very flexible approach, take a look at this blog post:
http://qlikviewnotes.blogspot.com/2008/09/loading-multiple-excel-sheets.html
and The QV Cookbbok example, "Load multiple sheets from Excel workbook". The first part of the example, "Mutli Sheet load" is just like your example except you don't need to filter out sheets. The SheetName variable in the script can be parsed to get the month and year for your MakeDate.
-Rob