this is not going to be a question, I'm just trying to find some advice.
Suppose I have a point shapefile (for example just two points, actually I have many more points) representing water control stations. The attribute table looks like:
ID X Y Cl Na
A 3480240 5887204 125.70 60.30
B 3480450 5887280 230.30 120.80
Now, how can I join another table that contains repeated measures of Cl
and Na
for each ID
? This could be the example of the other table (measures in different years) I want to join:
ID Cl Na Year
A 100.30 210.20 2010
A 120.40 200.30 2011
A 130.40 198.20 2012
B 101.00 199.20 2009
B 130.40 210.40 2010
B 140.60 210.00 2011
B 166.90 240.20 2012
I have tried both the QGIS standard join option and the mmqgis plugin (join from csv file) but the results are not as expected.
QGIS join option adds some columns to each ID
, but many fields have "NULL" attributes while mmqgis increased the number of rows for each ID
and each field contains the same value (e.g. Cl
values are always 120.20 for each year).
So I would just like to know if anybody has worked with this kind of data in order to understand the best way to handle multi-attribute field related to one single feature?