How to aggregate a matrix of attribute values into a single row
Page 1 / 1
Hi,
Try this.
- Create a new attribute which stores the non-null value stored by one of "TextVal", "NumVal", or "EntityVal". You can just concatenate the three attribute values since only one of them is filled per row, and set the value of "Property" to the new attribute name. The AttributeCreator can be used to do this.
- Aggregate the features with the Aggregator (Group By: Object-ID, Keep Input Attributes: Yes).
- Expose the possible "Property" values (255, 256, ... i.e. the attribute names for the resulting table) with the AttributeExposer.
- Optionally remove unnecessary attributes with the AttributeRemover.
Result:
Takashi
Hi,
Try this.
- Create a new attribute which stores the non-null value stored by one of "TextVal", "NumVal", or "EntityVal". You can just concatenate the three attribute values since only one of them is filled per row, and set the value of "Property" to the new attribute name. The AttributeCreator can be used to do this.
- Aggregate the features with the Aggregator (Group By: Object-ID, Keep Input Attributes: Yes).
- Expose the possible "Property" values (255, 256, ... i.e. the attribute names for the resulting table) with the AttributeExposer.
- Optionally remove unnecessary attributes with the AttributeRemover.
Result:
Takashi
Annika
Hi Takashi, sorry, forgot to post my name, it's Annika...that is awesome and exactly what I need. You saved the weekend, thanks a lot! Annika