Yes, this can be done in Load Script. If you have same field names then QlikView will automatically concatenate the fields and you will see only one table. However, if the names are different then you use forced concatenation. You can also add a column (Year) on the fly within your Load Script.
I hope this helps!
Cheers - DV
It may depend on how you want to include this year.
In the middle of the load statement, you can just include the year
a, b, c,
2011 as year]
or you can use the function filename() of filebasename() ( you can get more information in the QV Help) to get the year from the file name
Let us say that the files have names like:
Sales2010.xls, Sales 2011.xls.
You load script could be like this:
LOAD a,b, num(right( filebasename(), 4)) as Year
(biff, embedded labels, table is Sales$);
Hope this helps,