I am using an Attribute Value Mapper which works well but would like to refresh the mapping data (imported from excel file) at run time so that the Transformer always holds the latest up to date data without having to manually import. Any ideas? than

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 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

ok thanks David.

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.