Forum Discussion

NehaSha's avatar
NehaSha
Icon for Helper II rankHelper II
7 years ago
Solved

Map bubbles from 2 different tables without any connection need to show in one map

Hello Everyone!

Need help to the below mentioned scenario! 

 

User have all data for his location along with dclongitude and dclatitude and provide  competition data only have dc longitude and dclatitude  and state--no connection with user location 

 

1st table is connected to other matrix and have dropdown for the locations based on 1 or multiple location selection : 

 

Need to show bubbles for that location along with competition bubbles 

--how to show 2 different tables longitude latitude in one map 

--how to co-relate both tables dclat and dc long  

so based on user location selection zoom in --all nearby competition will automatically zoom in near to user location 

 

Thanks for help in advance!

Thanks,
Neha

Need Help
  • NehaSha's avatar
    NehaSha
    7 years ago

    Hi ,

     

    Thanks for your reply! Data is confidential

     

    Solution :

     

    creating a New Table with 4 columns LocationKey , dclongitude,dclatitude, Type 

    This Table will be related to Master Table from ClientCompany which contain Unique locationKey , dclongitude and dclatitude with all other infor 

    Competition Table Contain only dclongitude and dclatitude , I decided to create new column is location key related to master table , Purpose to find which competitor location belongs to which Client location , so that zoom in can be easy

    New table columns:

    Type will be able to define the Competition or ClientCompany in Map 

    or

    Map Legend will be Type :- for 2 different color based on Competition and ClientCompany

    dclongitude ---shows all values for both Types

    dclatitude  ---shows all values for both Types

     

    Thanks,

     

    Neha

3 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi NehaSha ,

     

    Could you please share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.

     

    Regards,

    Frank

    • NehaSha's avatar
      NehaSha
      Icon for Helper II rankHelper II
      7 years ago

      Hi ,

       

      Thanks for your reply! Data is confidential

       

      Solution :

       

      creating a New Table with 4 columns LocationKey , dclongitude,dclatitude, Type 

      This Table will be related to Master Table from ClientCompany which contain Unique locationKey , dclongitude and dclatitude with all other infor 

      Competition Table Contain only dclongitude and dclatitude , I decided to create new column is location key related to master table , Purpose to find which competitor location belongs to which Client location , so that zoom in can be easy

      New table columns:

      Type will be able to define the Competition or ClientCompany in Map 

      or

      Map Legend will be Type :- for 2 different color based on Competition and ClientCompany

      dclongitude ---shows all values for both Types

      dclatitude  ---shows all values for both Types

       

      Thanks,

       

      Neha

    • NehaSha's avatar
      NehaSha
      Icon for Helper II rankHelper II
      7 years ago

      Hi  v-frfei-msft ,

       

      Thanks for your reply! Data is confidential

       

      Solution :

       

      creating a New Table with 4 columns LocationKey , dclongitude,dclatitude, Type 

      This Table will be related to Master Table from ClientCompany which contain Unique locationKey , dclongitude and dclatitude with all other infor 

      Competition Table Contain only dclongitude and dclatitude , I decided to create new column is location key related to master table , Purpose to find which competitor location belongs to which Client location , so that zoom in can be easy

      New table columns:

      Type will be able to define the Competition or ClientCompany in Map 

      or

      Map Legend will be Type :- for 2 different color based on Competition and ClientCompany

      dclongitude ---shows all values for both Types

      dclatitude  ---shows all values for both Types

       

      Thanks,

       

      Neha