I have a bunch of Excel workbooks named "filenamex11-01-2010", "filenamex11-10-2010", etc. The filename is also the name of the one tab within workbook. However I don't have a date field in the data itself. Is there anyway to use the filename or tab name as the data for all the data? I expect I'd need to first setup some sort of calc field to parse it (so I'd end up with just "11-01-2010").
The data inside the workbook looks like this:
Station 1/Last week Last-Last Week Total Alerts/Last week Total Alerts etc...
Station 2/....
The data is cumulative each week, so I've created a calc field called Weekly Alerts to subtract the LastWeek - LastLastWeek to get the actual # of alerts for this week. What I'd normally have to do is insert a column with the date of the report for all rows so I could visualize each Station, Weekly Alerts by Date of Report.
Thanks!
Jeff
I do not currently know of any open source ETL software that can do what you are looking for, point it at a folder and read in file names and sheet names without setting up the metadata.
I would recommend a scripting language, I personally know what you are looking for can be done in VBScript, and I am sure others know if this can be done in Perl or Python or something else.
