I've got a map with spatial data that I want to merge with some non-spatial tables. The tables will become spatial based on unique numerical identifiers contained in a column shared with the spatial data.
I import the tables as .csv files and join it to the relevant layer without problem. However, I noticed that when I then query the combined attributes some have not made it into the joined table. This leaves me with mystery gaps in my data that are not easy to discover in most cases.
Has anyone had this experience before? Using QGIS 2.18.11