Skip to main content
Solved

Write down values from one column to another based on rule

  • November 21, 2019
  • 1 reply
  • 5 views

Forum|alt.badge.img

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 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.

View original
Did this help you find an answer to your question?

1 reply

redgeographics
Celebrity
Forum|alt.badge.img+50
  • Celebrity
  • Best Answer
  • November 21, 2019

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings