The aim is to show all mineral oil deposits of an specific area.
First I have the buildings as a shapefile. The address of every building is divided in City, street and housenumber. So there are three different attributes.
And I got a table with all addresses that have a mineral oil deposit. ( I know how to import it into QGIS as a csv-file). In this table the address is also divided in three attributes as in the shapefile of the buildings.
The problem is I have no single attribute that could be used for a join. Do you know any easy possibility to join them? Maybe to put the attribute street and the house number in one attribute?