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

2015-07-30 Thread 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

Re: [Qgis-developer] function similar to Excel VLOOKUP

2015-07-30 Thread 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

Re: [Qgis-developer] function similar to Excel VLOOKUP

2015-07-30 Thread DelazJ
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