I have been able to do a conversion (in FME2013) from an Access DB to a SQL Express DB(in Desktop Workbench), adding some transformers to grab data from three of the tables, two of which have primary keys, and running a SQL query executer I can populate a new table; querying out needed information from all three, (or inner join on the two with the key) this is all done one DBs at a time because the primary keys repeat.
I would now like to grab multiple Access DB’s all at once and do the same thing only grouping them together based on the DBs they originate from adding a new primary key field containing the file name of the Access DB in that field.
When I use the Full Filename Attribute from the FilemnamePartExtractor it combines all of the selected filenames adding special characters (“,**) I have removed them using the StringReplacer. I am at a point where I cannot seem to move forward successfully, due to my limited experience working with FME.
I am also wondering if this is the correct approach or is there a more straightforward method?
In the first and third writer I am using the FilemnamePartExtractor, StringReplacer, StringConcatenator and the BulkAttributeRenamer and dropping the values into a new SourceData… field.