Hi list.
This issue has been touched on several times, but I don't see a solution for me in any of the answers.
I have to read a number of Excel spreadsheets, and being spreadsheets, they vary very much in both content and structure.
I can read the spreadsheets with FeatureReader just fine, and I get both schema features with an attributes{} list of attributes, and generic data features with attributes in an unexposed state.
How do I utilize the schema features to dynamically expose whatever attributes are present in the data ?
Exposing attributes seems to be a design time issue only, and I haven't found any way to expose attributes dynamically.
Alternatively, can a (MS/SQL) writer accept a list of name/value items, and output these to the database as fields with values ?
I also need to merge several fme_feature_type's (i.e. multiple Excel sheets/tabs), so Dynamic Schema Definition won't work for me, I think.
Cheers.
