How to join datasets without a unique ID
Running into a problem, I have a IP address for a user, and wanting to reference the country of origin for IP address. I have imported a IP address database, which shows the IP start and IP end ranges for specific countries. I have modified these and the user IP address to numerical value. The plan was to use between to find the country.
However, I am running into an issue joining to data to be able to use the data. Visual example of the tables below;
user_id, user_name, user_ip
ip_range_start, ip_range_end, country_code
Needing to end up with the following;
user_id, user_name, user_ip, country_code