1 of 1 people found this helpful
Thanks for including an example.
So - The primary data source has ZIP codes. Some of those have characters in them (ie: X1A 0)
As such, the primary source is a geo type = zip but a a data type as a STRING. (you can view this by right clicking the ZIP_CODE column, select Change data type - String is selected).
In your secondary source, the zip_codes are all numeric. You need to change the data type (right click the column) and select STRING.
This will fix your issue.