Is there a way to prefix/concatenate the attribute name and a separator character to all of the values on that feature? For example, I have a feature with 60 attributes - can I retain the values of each cell, but have the attribute name appended to the values without having to manually create each attribute.
Input:
AttributeName
abc
def
hij
Output
AttributeName
AttributeName|abc
AttributeName|def
AttributeName|hij
Have you looked at the BulkAttributeRenamer?
a1=aa
b1=bb
a1|aa
b1|bbApologies @david_r for not being clear. For each of the 60 columns, I would like to append the name of the attribute to every value under that attribute.
+31I would use the AttributeExploder to get _attr_name and _attr_value attributes on the feature, and then a StringConcatenator to get the final result of _attr_name|_attr_value.
I would use the AttributeExploder to get _attr_name and _attr_value attributes on the feature, and then a StringConcatenator to get the final result of _attr_name|_attr_value.
In addition to the solution proposed by @cartoscro, here's one in Python that should have a more linear performance for larger datasets:
import fmeobjects
SEPARATOR = '|'
def processFeature(feature):
for attr in feature.getAllAttributeNames():
if not attr.startswith('fme_'):
value = feature.getAttribute(attr)
feature.setAttribute(attr, '%s%s%s' % (attr, SEPARATOR, value))
Also notice the mechanism for leaving the fme_* attributes untouched.
+31
I would use the AttributeExploder to get _attr_name and _attr_value attributes on the feature, and then a StringConcatenator to get the final result of _attr_name|_attr_value.
In addition to the solution proposed by @cartoscro, here's one in Python that should have a more linear performance for larger datasets:
import fmeobjects
SEPARATOR = '|'
def processFeature(feature):
for attr in feature.getAllAttributeNames():
if not attr.startswith('fme_'):
value = feature.getAttribute(attr)
feature.setAttribute(attr, '%s%s%s' % (attr, SEPARATOR, value))
Also notice the mechanism for leaving the fme_* attributes untouched.