0

I have two columns in a attribute table.

The first one has numbers from 1 to 30 in different frequencies. For example number 1 20 times, 2 35 times and so on.

In the second column I want to write for every number (all frequencies) a specific code of strings. For example All 1 = abc, all 2 = def...

My first step is to separate the number of interest (in picture below it's number 5)

enter image description here

But after this I have problems to find a way to fill the second column with the specific code for the number (in picture's case all 5 should be BWk) automatically.

I can write the specific code in every single row of the code's columns but's that's to much work.

Maybe someone can help me with an advice of what can I do with the field calculator to get through it.

Maybe it's possible with copy & paste but I don't find out yet how I can selected more cells simultaneous and paste some information.

Improve this question

1 Answer 1

Reset to default
3

in the field calculator try this:

update your field Code with this: 

if("DN" = 5, 'BWk', "Code")

what it does is:

  • Check if the value of your first field DN is 5
  • if this is true it will set the value in Code to BWk
  • if the statement is false ( DN is for example 42) it will leave Code as it is

Take note of the single and double quotation. Single quotations are strings/text while double quotations are fields

Improve this answer
1
  • Great. It works! Thank you for the code and for the explanations,either!!
    – Hark
    Jul 27, 2017 at 9:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.