I've got a shapefile lines with ID attribute and .dbf with values which corresponds do ID. Every value in dbf is in different record.
I want to style lines and display label using these values from dbf. I tried to use Join tool in layer's properties in QGIS but it joined only a few of values.
I shown you just a simplified example...
My "real life" problem is a little bit different. I've got a shapefile with geometry of roads. Every link of the roads has a unique ID attribute. On the other hand I've got a dbf file with information about road restriction.
Structure of dbf is: road_linkID - type - value
road_link1 - max_height - 2
road_link1 - speed limit - 50
road_link1 - max_weight - 3,5
road_link2 - speedlimit - 60
road_link3 - max_weight - 3,5
road_link3 - speedlimit - 60
road_link3 - max_height - 4
When I'm using layer\properties\join to my road.shp adds one column with only one parameter:
road_link1 - max_height - 2
road_link2 - speedlimit - 60
road_link3 - max_weight - 3,5