Hi, I am working on translating data from numbers to phrases. I know using the String Replacer and Attribute Value Mapper is the best for this, but I am having issues when trying to map more than one value to one field. An example would be the reason_of_given_set has multiple values, I need these values to populate with given phrases, each number represents a phrase. I provided the parameters of the transformer I am using below. I also tried creating 14 different string replacers to represent each number and each time the output shows blank at the attributes with multiple values. 
I am probably using the Attribute Value Mapper transformer incorrectly and its not designed to do this, or I have the parameters set incorrectly. Does anyone know how I can fix this?
Question
Can the attribute value mapper transformer map multiple values in one record?
+31- Influencer
Do you have geometry associated with these records? If not, you could do something like this:
- Use an AttributeSplitter to create a list of those attributes
- With ListExploder, create separate features for each list item.
- Process those through your AttributeValueMapper, and then Aggregate the results (Group By set to _element_index, and Attributes to Concatenate set to _looked_up_reason_of_given_set).
If you do have geometry associated, the Aggregator may skew that. You could always Deaggregate after this workflow, I suppose.
+63
Do you have geometry associated with these records? If not, you could do something like this:
- Use an AttributeSplitter to create a list of those attributes
- With ListExploder, create separate features for each list item.
- Process those through your AttributeValueMapper, and then Aggregate the results (Group By set to _element_index, and Attributes to Concatenate set to _looked_up_reason_of_given_set).
If you do have geometry associated, the Aggregator may skew that. You could always Deaggregate after this workflow, I suppose.
If there is geometry, you can use a GeometryExtractor to temporarily save that to an attribute and then after aggregating a GeometryReplacer to rebuild it.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.