How about a " Join "
QGIS join
Il 30/07/2015 13.06, Zoltan Szecsei ha scritto:
Hi,
How could I implement something like vlookup in QGIS?
I have a shapefile with 2000 polygons and column 1 of its attribute
table has a code value.
Using the code in this column 1, I need to look up which row of a CSV
file has that code, and return column 2 of the CSV file.
This returned value must then be placed into a new column (say column
6) on the shapefile attribute table.
I could pre-add the new column to this shapefile, and then run the
vlookup equivalent too, of course.
I tried this by opening the DBF file in Libreoffice calc, sorting the
columns, adding the extra two columns of my lookup data, then ran
vlookup and saved/closed the DBF file.
Once back in QGIS the attributes ended up being linked to the wrong
polygons (probably because I sorted the DBF file outside of QGIS).
Thanks in advance,
Zoltan
_______________________________________________
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-developer