[Qgis-developer] function similar to Excel VLOOKUP - SOLVED

[Zoltan Szecsei]

Awesome. Thank you.

I added the extra column to the shapefile attributes, joined the 
shapefile to the CSV file, and then updated the new column in my 
shapefile using:
attribute($currentfeature,'joinedcolumn')  (NOTE: single quotes for 
field name)

I'm sure I could have skipped the Join step and just used getfeature as 
suggested below, but I went the Join route anyway.

Big thanks,
Zoltan


On 2015/07/30 14:34, DelazJ wrote:
> Hi,
> I think combining getFeature and attribute functions should help u do 
> that in the field calculator, though I haven't used them on csv files.
> Assuming col1 in your csv contains also the code you are looking for, 
> applying this expression on shapefile "col 6" in QGIS field calculator 
> may do the job:
> attribute (getFeature ('mycsvfile', 'mycsv_col1', "myshape_col1"), 'col2')
>
> Regards,
> DelazJ
>
> 2015-07-30 13:06 GMT+02:00 Zoltan Szecsei <zoltans at geograph.co.za 
> <mailto:zoltans at geograph.co.za>>:
>
>     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
>
>
>     -- 
>
>     ===========================================
>     Zoltan Szecsei PrGISc [PGP0031]
>     Geograph (Pty) Ltd.
>     GIS and Photogrammetric Services
>
>     P.O. Box 7, Muizenberg 7950, South Africa.
>
>     Mobile: +27-83-6004028 <tel:%2B27-83-6004028>
>     Fax: +27-86-6115323 <tel:%2B27-86-6115323> www.geograph.co.za
>     <http://www.geograph.co.za>
>     ===========================================
>
>     _______________________________________________
>     Qgis-developer mailing list
>     Qgis-developer at lists.osgeo.org <mailto:Qgis-developer at lists.osgeo.org>
>     http://lists.osgeo.org/mailman/listinfo/qgis-developer
>
>
>
>
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer

-- 

===========================================
Zoltan Szecsei PrGISc [PGP0031]
Geograph (Pty) Ltd.
GIS and Photogrammetric Services

P.O. Box 7, Muizenberg 7950, South Africa.

Mobile: +27-83-6004028
Fax:    +27-86-6115323     www.geograph.co.za
===========================================

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20150730/f8fd5653/attachment-0001.html>