Multiple workbooks into one based on filename

Hi,

I would use the fme_basename to extract the digits and group with the aggregator, make sure you are keeping the attributes when doing that .

Here's how I solved it.

1. Set up a reader to read all Excel files in a directory and output a single feature type. I'm assuming they all have the same attribute structure.
2. Expose the fme_basename attribute. This holds the original filename.
3. Assuming the filename always follows that structure I've used an AttributeSplitter to split it with the _ (underscore) as split character. This creates a list with list{2} containing "Cars" or "Buses" and list{3} the 3-digit code.
4. Set up an AttributeManager or AttributeCreator to create new attributes "sheet" and "file" and fill them with list{2} and list{3} respectively.
5. Set up an Excel writer and use the attribute "sheet" to fill the sheet name, then set the fanout option in the navigator and use "file" for the filename.

Hope this helps. I've attached a template with my workspace and input files.

excelcombiner.fmwt