Change string to Getting integer based on string value in another field using QGIS

I have a big data set with a column name "CORINE" with strings in it. I want to change these individualsindividual strings into integers and put itthem into a new column, so that iI can create a raster layer out of the created values. I tried this code in the field calculator.

CASE 
  WHEN "CORINE" = "AG" 
  THEN 1
  WHEN "CORINE" = "BG" 
  THEN 2
  WHEN "CORINE" = "LW" 
  THEN 3
  WHEN "CORINE" = "NW" 
  THEN 4
  WHEN "CORINE" = "MW" 
  THEN 5
  WHEN "CORINE" = "WW" 
  THEN 6
  WHEN "CORINE" = "WA" 
  THEN 7
  WHEN "CORINE" = "DK" 
  THEN 8
  WHEN "CORINE" = "LN" 
  THEN 9
  WHEN "CORINE" = "NV" 
  THEN 11
  WHEN "CORINE" = "SU" 
  THEN 12
  WHEN "CORINE" = "SV" 
  THEN 13
  WHEN "CORINE" = "TM" 
  THEN 14  
  ELSE 0
END

CASE 
    WHEN "CORINE" = "AG" THEN 1
    WHEN "CORINE" = "BG" THEN 2
    WHEN "CORINE" = "LW" THEN 3
    WHEN "CORINE" = "NW" THEN 4
    WHEN "CORINE" = "MW" THEN 5
    WHEN "CORINE" = "WW" THEN 6
    WHEN "CORINE" = "WA" THEN 7
    WHEN "CORINE" = "DK" THEN 8
    WHEN "CORINE" = "LN" THEN 9
    WHEN "CORINE" = "NV" THEN 11
    WHEN "CORINE" = "SU" THEN 12
    WHEN "CORINE" = "SV" THEN 13
    WHEN "CORINE" = "TM" THEN 14
    ELSE 0
END

But after the calculations, all the values in the new column are 00. What is my mistake?

Change string to integer QGIS

I have a big data set with a column name "CORINE" with strings in it. I want to change these individuals strings into integers and put it into a new column, so that i can create a raster layer out of the created values. I tried this code in the field calculator.

CASE 
  WHEN "CORINE" = "AG" 
  THEN 1
  WHEN "CORINE" = "BG" 
  THEN 2
  WHEN "CORINE" = "LW" 
  THEN 3
  WHEN "CORINE" = "NW" 
  THEN 4
  WHEN "CORINE" = "MW" 
  THEN 5
  WHEN "CORINE" = "WW" 
  THEN 6
  WHEN "CORINE" = "WA" 
  THEN 7
  WHEN "CORINE" = "DK" 
  THEN 8
  WHEN "CORINE" = "LN" 
  THEN 9
  WHEN "CORINE" = "NV" 
  THEN 11
  WHEN "CORINE" = "SU" 
  THEN 12
  WHEN "CORINE" = "SV" 
  THEN 13
  WHEN "CORINE" = "TM" 
  THEN 14  
  ELSE 0
END

But after the calculations all the values in the new column are 0. What is my mistake?

Getting integer based on string value in another field using QGIS

I have a big data set with a column name "CORINE" with strings in it. I want to change these individual strings into integers and put them into a new column so that I can create a raster layer out of the created values. I tried this code in the field calculator.

CASE 
    WHEN "CORINE" = "AG" THEN 1
    WHEN "CORINE" = "BG" THEN 2
    WHEN "CORINE" = "LW" THEN 3
    WHEN "CORINE" = "NW" THEN 4
    WHEN "CORINE" = "MW" THEN 5
    WHEN "CORINE" = "WW" THEN 6
    WHEN "CORINE" = "WA" THEN 7
    WHEN "CORINE" = "DK" THEN 8
    WHEN "CORINE" = "LN" THEN 9
    WHEN "CORINE" = "NV" THEN 11
    WHEN "CORINE" = "SU" THEN 12
    WHEN "CORINE" = "SV" THEN 13
    WHEN "CORINE" = "TM" THEN 14
    ELSE 0
END

But after the calculations, all the values in the new column are 0. What is my mistake?

naming; typo; removed closing

Source Link

edited Nov 25, 2021 at 17:20

Vince

20.3k
16
48
65

Change string to integer qgisQGIS

I have a big data set with a columnnamecolumn name "CORINE" with strings in it. I want to change these individuals strings into integers and put it into a new column, so that i can create a raster layer out of the created values. I tried this code in the field calculator.

CASE 
  WHEN "CORINE" = "AG" 
  THEN 1
  WHEN "CORINE" = "BG" 
  THEN 2
  WHEN "CORINE" = "LW" 
  THEN 3
  WHEN "CORINE" = "NW" 
  THEN 4
  WHEN "CORINE" = "MW" 
  THEN 5
  WHEN "CORINE" = "WW" 
  THEN 6
  WHEN "CORINE" = "WA" 
  THEN 7
  WHEN "CORINE" = "DK" 
  THEN 8
  WHEN "CORINE" = "LN" 
  THEN 9
  WHEN "CORINE" = "NV" 
  THEN 11
  WHEN "CORINE" = "SU" 
  THEN 12
  WHEN "CORINE" = "SV" 
  THEN 13
  WHEN "CORINE" = "TM" 
  THEN 14  
  ELSE 0
END

But after the calculations all the values in the new column are 0. What is my mistake?

Cheers

Change string to integer qgis

I have a big data set with a columnname "CORINE" with strings in it. I want to change these individuals strings into integers and put it into a new column, so that i can create a raster layer out of the created values. I tried this code in the field calculator.

CASE 
  WHEN "CORINE" = "AG" 
  THEN 1
  WHEN "CORINE" = "BG" 
  THEN 2
  WHEN "CORINE" = "LW" 
  THEN 3
  WHEN "CORINE" = "NW" 
  THEN 4
  WHEN "CORINE" = "MW" 
  THEN 5
  WHEN "CORINE" = "WW" 
  THEN 6
  WHEN "CORINE" = "WA" 
  THEN 7
  WHEN "CORINE" = "DK" 
  THEN 8
  WHEN "CORINE" = "LN" 
  THEN 9
  WHEN "CORINE" = "NV" 
  THEN 11
  WHEN "CORINE" = "SU" 
  THEN 12
  WHEN "CORINE" = "SV" 
  THEN 13
  WHEN "CORINE" = "TM" 
  THEN 14  
  ELSE 0
END

But after the calculations all the values in the new column are 0. What is my mistake?

Cheers

Change string to integer QGIS

I have a big data set with a column name "CORINE" with strings in it. I want to change these individuals strings into integers and put it into a new column, so that i can create a raster layer out of the created values. I tried this code in the field calculator.

CASE 
  WHEN "CORINE" = "AG" 
  THEN 1
  WHEN "CORINE" = "BG" 
  THEN 2
  WHEN "CORINE" = "LW" 
  THEN 3
  WHEN "CORINE" = "NW" 
  THEN 4
  WHEN "CORINE" = "MW" 
  THEN 5
  WHEN "CORINE" = "WW" 
  THEN 6
  WHEN "CORINE" = "WA" 
  THEN 7
  WHEN "CORINE" = "DK" 
  THEN 8
  WHEN "CORINE" = "LN" 
  THEN 9
  WHEN "CORINE" = "NV" 
  THEN 11
  WHEN "CORINE" = "SU" 
  THEN 12
  WHEN "CORINE" = "SV" 
  THEN 13
  WHEN "CORINE" = "TM" 
  THEN 14  
  ELSE 0
END

But after the calculations all the values in the new column are 0. What is my mistake?

added 3 characters in body

Source Link

edited Nov 25, 2021 at 15:53

TomazicM

27k
23
31
42

I have a big data set with a columnname "CORINE" with strings in it. I want to change these individuals strings into integers and put it into a new column, so that i can create a raster layer out of the created values. I tried this code in the field calculator.

´´ CASE WHEN "CORINE" = "AG" THEN 1 WHEN "CORINE" = "BG" THEN 2 WHEN "CORINE" = "LW" THEN 3 WHEN "CORINE" = "NW" THEN 4 WHEN "CORINE" = "MW" THEN 5 WHEN "CORINE" = "WW" THEN 6 WHEN "CORINE" = "WA" THEN 7 WHEN "CORINE" = "DK" THEN 8 WHEN "CORINE" = "LN" THEN 9 WHEN "CORINE" = "NV" THEN 11 WHEN "CORINE" = "SU" THEN 12 WHEN "CORINE" = "SV" THEN 13 WHEN "CORINE" = "TM" THEN 14
ELSE 0 END´´

CASE 
  WHEN "CORINE" = "AG" 
  THEN 1
  WHEN "CORINE" = "BG" 
  THEN 2
  WHEN "CORINE" = "LW" 
  THEN 3
  WHEN "CORINE" = "NW" 
  THEN 4
  WHEN "CORINE" = "MW" 
  THEN 5
  WHEN "CORINE" = "WW" 
  THEN 6
  WHEN "CORINE" = "WA" 
  THEN 7
  WHEN "CORINE" = "DK" 
  THEN 8
  WHEN "CORINE" = "LN" 
  THEN 9
  WHEN "CORINE" = "NV" 
  THEN 11
  WHEN "CORINE" = "SU" 
  THEN 12
  WHEN "CORINE" = "SV" 
  THEN 13
  WHEN "CORINE" = "TM" 
  THEN 14  
  ELSE 0
END

But after the calculations all the values in the new column are 0. What is my mistake?

Cheers

I have a big data set with a columnname "CORINE" with strings in it. I want to change these individuals strings into integers and put it into a new column, so that i can create a raster layer out of the created values. I tried this code in the field calculator.

´´ CASE WHEN "CORINE" = "AG" THEN 1 WHEN "CORINE" = "BG" THEN 2 WHEN "CORINE" = "LW" THEN 3 WHEN "CORINE" = "NW" THEN 4 WHEN "CORINE" = "MW" THEN 5 WHEN "CORINE" = "WW" THEN 6 WHEN "CORINE" = "WA" THEN 7 WHEN "CORINE" = "DK" THEN 8 WHEN "CORINE" = "LN" THEN 9 WHEN "CORINE" = "NV" THEN 11 WHEN "CORINE" = "SU" THEN 12 WHEN "CORINE" = "SV" THEN 13 WHEN "CORINE" = "TM" THEN 14
ELSE 0 END´´

But after the calculations all the values in the new column are 0. What is my mistake?

Cheers

I have a big data set with a columnname "CORINE" with strings in it. I want to change these individuals strings into integers and put it into a new column, so that i can create a raster layer out of the created values. I tried this code in the field calculator.

CASE 
  WHEN "CORINE" = "AG" 
  THEN 1
  WHEN "CORINE" = "BG" 
  THEN 2
  WHEN "CORINE" = "LW" 
  THEN 3
  WHEN "CORINE" = "NW" 
  THEN 4
  WHEN "CORINE" = "MW" 
  THEN 5
  WHEN "CORINE" = "WW" 
  THEN 6
  WHEN "CORINE" = "WA" 
  THEN 7
  WHEN "CORINE" = "DK" 
  THEN 8
  WHEN "CORINE" = "LN" 
  THEN 9
  WHEN "CORINE" = "NV" 
  THEN 11
  WHEN "CORINE" = "SU" 
  THEN 12
  WHEN "CORINE" = "SV" 
  THEN 13
  WHEN "CORINE" = "TM" 
  THEN 14  
  ELSE 0
END

But after the calculations all the values in the new column are 0. What is my mistake?

Cheers

Source Link

asked Nov 25, 2021 at 15:51

Mike

43
2

Loading

Stack Exchange Network

Return to Question

Change string to Getting integer based on string value in another field using QGIS

Change string to integer QGIS

Getting integer based on string value in another field using QGIS

Change string to integer qgisQGIS

Change string to integer qgis

Change string to integer QGIS