I want to "merge" two layers and export the resulting table of attributes into a csv file. The two layers are as follows:
- MSA level information: It has geometric information that creates the polygons and attributes of the MSAs. For some MSAs, some attributes are NULL, for others there is a string.
- County level information: It has geometric information at the county level (to generate the polygons) and attributes at the same level. As before, the attributes are "NULL" for some cells and strings for others.
When selecting the two layers, the overlapping map is perfect. However, when I try to use "Join Attributes by Location", the layers are merged but only the geometric information is saved, and the attributes are lost. If I use MMQGIS to do a "Spatial Join" of the two layers, I get an error message saying that there are "duplicate output field names from different layers", which is true as all geographic information is labeled the same in the original MSA and county layers.
So, how should I proceed to merge this two layers and get the merged table of attributes with the attributes coming from both layers?
I am using QGIS 2.8.6-Wien on Ubuntu 16.04