Hello, I uploaded an excel spreadsheet with 14720 tracking numbers (7 are duplicates beccause somehow they were sent to different locations). I then create a relationship by tracking number to a table with years worth of tracking #'s and probably tons of duplicates from data entry errors.
Column A is tracking from my uploaded file. Colin B will be the tracking # from the primary tracking table.
Q1. If I select the option 2 join which is show ALL records from my unloaded table and only those that match from the primary. What causes the results to be 127 records short?
Q2. I've seen similar instances with more records than the table has, what leads to that?