You can do ist with:

------------------------------------------
case
when “DESCRIPTION” = 'sample1' then 1
when “DESCRIPTION” = 'sample2' then 2
...
when “DESCRIPTION” = 'sample25' then 25
end
------------------------------------------
Claas

Am 15.11.2016 um 21:51 schrieb Azzurra Lentini:
Dear all,

I have an attribute table (associated to a shape file).

One of the field  is a string type field and his name is “DESCRIPTION” ,
I need this field as an  INT number.

The field “description” is formed by 25 different samples and around 350
records (so for every sample there are different records with the same
description).

SO I create a new field “descriptionINT” and I would like to fill the
field with 25 numbers (1, 2, 3,.... 25) associated to the 25 different
sample and 350 records.

How I can do?

Till now, I was first selecting the records related to the first sample
and I was giving the number, for example 1 (with field calculator) to
all the records related to the same sample.

But I am doing this one by one.. that means every time a do a new
selection and I give a new number with field calculator.

Do you know a faster way (query)  to do this ?


​thanks A.L. ​

--
Dr. Hydrogeologist
AZZURRA LENTINI
Expert of evaluation environmental hazards
GIS application
Haity Mobile Tel: 0050946057393
++++++++++++++++++++++++++
Italy Mobile Tel.: **(39) 338 24 40 676
++++++++++++++++++++++++++
SKYPE azzurrahydro
++++++++++++++++++++++++++
azzurralent...@gmail.com <mailto:azzurralent...@gmail.com>
++++++++++++++++++++++++++
*Par respect pour l'environnement,*

*n'imprimez ce mail qu'en cas d'absolue nécessité*








_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user



--
-----------------------------------------
GKG-Kassel - Dr.-Ing. Claas Leiner
QGIS-Support und mehr

Geodatenservice, Kartenwerkstatt &
GIS-Schule Kassel

Wilhelmshöher Allee 304 E
34131 Kassel
Tel. 0561/56013445
claas.lei...@gkg-kassel.de
----------------------------------------
http://www.gkg-kassel.de
----------------------------------------
Unterstützen Sie QGIS
QGIS-DE e.V. | http://qgis.de
QGIS Projekt | http://qgis.org/de/site/
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Reply via email to