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.
Re: Create a new table that match information from 2 tables
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