I have one table that contains 450 locations and a table that has 10'000 rows containing data and no spatial information. I have a column that allows me to join them. The issue is that I want to have the joinig to take place by having my data table as main table. Therefore the solution of using the data table and converting it to a shape data and joining it with my data layer is not an option since it creates a file with only 450 rows and which obviously was not the intended result. What would be the solution to this problem.
If I understand your question correctly, you could try the following:
- Add the .csv file with the 450 locations layer as a Delimited Text Layer and select the appropriate options
- Add the other .csv file again as a Delimited Text Layer but select the No geometry (attribute only table) option
From the Processing plugin, select the Join attributes table algorithm, add both layers as the Input layers and select the same Column that both layers have as the Table field.
NB: I haven't tested this method on .csv files but it may still work.