How should I create a map loading geographic data?
I tried to create a map loading geographic data. A customer base with the latitude and longitude of each client but it does not show the points on the sheet inside my map.
The format of my file is EXCEL:
CompanyName
Country
City
CityLatitude
CityLongitude
Company1
Argentina
Buenos Aires
-34.60639
-58.37383
Company2
Argentina
Rosario
-32.945081
-60.642199
Company3
Argentina
Cordoba
-31.423370
-64.177876
The steps I took are the following:
1- Create a new app called maps
2- Add data from the data manager
3- In the data loader I unlocked "Automatically generated section"
And modified the upload script:
LOAD
CompanyName,
Country,
City,
CityLatitude,
CityLongitude,
GeoMakePoint(CityLatitude,CityLongitude) as CityMapPoint
FROM [lib://Sense/Mapas.xlsx]
(ooxml, embedded labels, table is [Reports (10)]);