Create a new table that match information from 2 tables
I am trying to make a map using 2 different tables.
The Data table has the provider info and data. The Location table is a big one which have the location information, including latitude and longitude for the GeoMakePoint function, of every city in Europe. This one is used as a support for the Data table.
I want to have a new table with all the Data table information and ONLY all the location information that match Postal Code.
Then I could use this table to place the providers on my map.
If you think there is a better way than creating a new table I’ll enjoyed it.
I have tried many things but the map always displayed all the location instead of the matched ones.
Another option is to use applymap() function to add the lat and long to your data. or simply have the locations load as a separate table and have the map only show locations where there is a value in your data