Skip to main content
Open

Bulk AttributeValueMapper

Related products:Transformers
  • February 28, 2018
  • 3 replies
  • 101 views
C

It would be good to replace the attribute value mapper with a ‘bulk attribute value mapper’ tool that could do the following:

1. Instead of importing data and it being static - it would be good for the tool to reference a db table/file dynamically so as to always pull in the latest data.

2. Instead of only handling one attribute at a time, it would be good to update multiple attributes at once from multiple lookup locations.

Examples

Source AttributeDatabase/FileFeatureTypeLookup Code AttributeLookup Value Attribute
MATERIALOracle GIS_DBLU_MATERIALLCODELVALUE
BEDDINGBeddingLookup.xlsxSheet 1CodeValue

In this example the Material AC would be value mapped to Asbestos Cement and the bedding type SND would be value mapped Sand

I understand that this can be done at the moment using a series of feature mergers with process duplicates enables, but this is something that comes up quite frequently as we have multiple datasources that only store the codes and regularly need to be updates to have the description field.

3 replies

lars_de_vries
Forum|alt.badge.img+10

I would use a DatabaseJoiner for the use case you describe. Now you would need multiple DatabaseJoiners.

I would suggest BulkAttributeValueJoiner as the transformer name.

mel
Contributor
Forum|alt.badge.img+7
  • melContributor
  • Contributor
  • January 28, 2021

I just need a simple one where you can have the same list apply to multiple fields and update the values in the field being looked at. I just finished copying the Attribute value mapper 15 times to apply the same list to multiple fields to replace the value in the field. The string replacer doesn't work with the data issue we are having to fix.

bark0s
Contributor
Forum|alt.badge.img+4
  • bark0sContributor
  • Contributor
  • July 1, 2025

Being able to populate the left hand side, the “Input Value” from the feature cache would be very sensible.  It’s so sensible that it should be fundamental.  Being able to then group those values, and make multiple groups would be great also.  So that I could then map n values in group 1 to a, n values in group 2 to b, etc.  

 

I don’t know whether that makes it a bulk attribute value mapper but the existing AttributeValueMapper is screaming out to populate Input Value from Cache.  It’s confounding that it isn’t included functionality already.  

esietinga

Community Stats

32,180
Posts
122,171
Replies
39,855
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.