How should I create a map loading geographic data?

[#1]

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)]);

4- I clicked "Upload Data"

5- Create a new sheet and drag a map

6- I added the dimension "City"

But it did not show me the points.

What is the problem?

Thanks for your helps!

[jneppl]

Hey, your data from CityLatitude and CityLongditude has to be with comma and not with point.

Company1	Argentina	Buenos Aires	-34,60639	-58,37383
Company2	Argentina	Rosario	-32,945081'	-60,642199

I was using bubble layer with dimension "City" and for Latitude / ID use CityLatitude, for Longitude use CityLongitude.

That worked for me.

Regards