[Qgis-user] field calculator and query: asking help for faster solution!!!

[Azzurra Lentini]

Dear Claas
yes thanks a lot.. it is working.

and thanks to all for the answers.

Azzu

2016-11-15 22:12 GMT+01:00 Claas Leiner <claas.leiner at gkg-kassel.de>:

>
> 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
>> ++++++++++++++++++++++++++
>> azzurralentini at gmail.com <mailto:azzurralentini at gmail.com>
>> ++++++++++++++++++++++++++
>> *Par respect pour l'environnement,*
>>
>> *n'imprimez ce mail qu'en cas d'absolue nécessité*
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at 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.leiner at 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 at lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user




-- 
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
++++++++++++++++++++++++++
azzurralentini at gmail.com
++++++++++++++++++++++++++
*Par respect pour l'environnement,*

*n'imprimez ce mail qu'en cas d'absolue nécessité*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20161115/7d3fc9a5/attachment.html>