Hello everyone, I need help. I got excel with data that looks like this picture. So, I have two blocks in excel name "CR" and "M". I need to compare attribute "Ownerstag" from block "M" to attribute "Location" from block "CR" and if they are the same then I need to write values from attribute M (column J) from block "M" in attribute "Location" from block "CR". Thanks in advance.
Best Answer
Write down values from one column to another based on rule
Best answer by redgeographics
You'll first need to split your dataset based on the Name field, you can use an AttributeFilter for that, and then use a FeatureMerger to join them back together again, based on Location/Ownerstag. Then finally an AttributeManager to put the value of field M in Location.
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.
+62- Celebrity
- Best Answer
You'll first need to split your dataset based on the Name field, you can use an AttributeFilter for that, and then use a FeatureMerger to join them back together again, based on Location/Ownerstag. Then finally an AttributeManager to put the value of field M in Location.