You'll have to replace the AttributeValueMapper with something else. My go-to is to use a FeatureReader to read the Excel data, then e.g. a FeatureMerger to join the lookup values with your data.
Hi nick,
The AttributeValueMapper has a button on it to 'import' from dataset. You can perform this from time to time to update the mapping definition
The other way(s) to achieve would be to use SchemaMapper with the Feature Type mapping. You need to use the fme_feature_type format attribute... copying it in an attributecreator/manager.
Perhaps you can attach you fme workbench as an fmwt (template) and maybe we can send it back to you. Let us know the fme build/version
You'll have to replace the AttributeValueMapper with something else. My go-to is to use a FeatureReader to read the Excel data, then e.g. a FeatureMerger to join the lookup values with your data.
ok thanks David.
Hi nick,
The AttributeValueMapper has a button on it to 'import' from dataset. You can perform this from time to time to update the mapping definitionThe other way(s) to achieve would be to use SchemaMapper with the Feature Type mapping. You need to use the fme_feature_type format attribute... copying it in an attributecreator/manager.
Perhaps you can attach you fme workbench as an fmwt (template) and maybe we can send it back to you. Let us know the fme build/version
Many thanks for response. I think on balance I will use the Feature Reader/Merger. This adds a few more steps to process (see screenshot) but recognising there is no current method to make the AttributeValueMapper 'dynamic', it works best for my purposes.