Solved
How to aggregate a matrix of attribute values into a single row
How to aggregate a matrix of attribute values into a single row
Best answer by 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
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
- Best Answer
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