7 Replies Latest reply: May 15, 2018 2:49 AM by Mikael Scorielle RSS

    Create a new table that match information from 2 tables

    David Munoz

      Hello,

      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.


      Captura.PNG


      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.


      Thank you for your help.