[Qgis-developer] function similar to Excel VLOOKUP

[Roy]

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
>
>