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.
+40- Influencer
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.
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.