Solved

Write down values from one column to another based on rule

  • 21 November 2019
  • 1 reply
  • 0 views

Badge

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.

icon

Best answer by redgeographics 21 November 2019, 15:48

View original

1 reply

Userlevel 5
Badge +25

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.

Reply