I have a point shape file contains 200,915 point features.
I also have a .xlsx file (MS 2013) that contains 113,214 features with a common ID; matching the shape file.
When I was trying to join the xlsx file with shape file, i found 105,350 features in joined table.
I was wondering why I'm missing data in joined table?
What might be the solution for this?
N.B. I tried to join files in several formats (.csv, .txt: unicode, .txt: MSDOS, .xlsx) and got the same result.
I can say for sure that all 113,214 data ID are existed in shape file.
What can be done at this point? Any idea?
Your quick response is highly appreciated.