I'm trying to monitor the capacity of a warehouse.
Every day I have a new file excel (today it is called warehouse_25052020, tomorrow it will be warehouse_26052020, and so on), which is a snapshot of the items I have in the warehouse. The file has always the same columns.
I'd like to load every day the new snapshot of the warehouse adding a column with the date I have in the title of the excel file.
Due to the large size of the file I'd like to have QVD files.
