I have a point shapefile and a CSV file containing various attributes and three columns (here: street
,num
,addnum
) based on which I would like to join both tables like
attribute1;...;attributen;street;num;addnum
1;...;100;Goethestr.;10;A
Since 'Straße' might be abbreviated or not and lower/uppercase might not be used consistent, I generate a virtual field adr
for each table upon wich I'd like to build a join by an expression like
replace(lower(if("addnum" is null, "street" || "num", "street" || "num" || "addnum")),'str.','straße')
I create a join on the point shapefile like this:
but as a result I get NULL
values for the prefixed joined attributes/fields:
What might be the problem? Virtual fields not suitable for joins? [QGIS 2.14.5LTR]