Hi Helen,
When you say that there will be a new sheet every month do mean a new sheet (tab) will be added to this Excel file or will there be a new file for the month?
If there is going to be a new file every month then it's very easy. If all the columns are identical for each month then put all the files into one folder. It's good practice to add the path to this folder to the script as a variable:
LET vxlsFolder = 'insert path here ';
Orders:
LOAD OrderID,
ProductID,
Product,
CustomerID,
EmployeeID,
OrderDate,
Margin,
Sales,
Cost,
Quantity
FROM
$(vxlsFolder)\*.xls
(biff, embedded labels, table is Orders$);
table is Orders$ here means that the script will extract from a sheet called Orders like you have in the file you uploaded.
Save your files to your folder and create your script to read one of them. When it's working then edit the line
$(vxlsFolder)\FilenameYouUseToTest.xls;
to
$(vxlsFolder)\*.xls
replacing the filename with '*'.
The script will then concatenate all the lines from the files into a single table Order.
Good luck
Andrew
