I already asked in previous question QGIS table join issue, how to join shape file data and CSV data which contain multiple SAME ID for one object?
Shape file contains columns: object id, area, height etc
CSV contains columns: object id, materials as brick, metal, concrete etc
So first I was joining them by JOIN option, but the numbers did not match as the software only recognises one value of the field and overwrites it to all other same IDs.
I was offered solution Project>Properties>Relations and I used instructions on: https://docs.qgis.org/testing/en/docs/user_manual/working_with_vector/attribute_table.html#id40. But I have over 84000 rows and don't have time to go through all of them and make connections. Further this option does not seem to have all the information I need for example in the attribute table. I would ideally like to be able to do this one-to-many join such that I could have overview of each material (concrete, steel, brick etc) for each field (I did not figured that out with relation).
Join table would be ideal but as stated the numbers do not match so it is issue with representation. Also it is important to have all materials for each field as they will be intersected with different layers and the correct amounts are needed for further calculations.