4 Replies Latest reply on Jan 11, 2016 12:56 PM by Javier Rubio

Change latitude and longitude with point separator to comma separator

Javier Rubio Jan 8, 2016 6:29 AM

Hi all,

I'm trying analyse a database with latitude and longitude fields but these are using a point as separator and I are recognized as a String.

I receive this type of files every month and I don't want to manually change the files to comma to be recognized as latitude and longitude. Here you have an example.

Do you know any way to work with these data in tableau to be recognized?

Thanks in advance

Javi

1. Re: Change latitude and longitude with point separator to comma separator

Thomas McCullough Jan 8, 2016 6:50 AM (in response to Javier Rubio)

Javi,

You can connect this to Tableau and change the data type from WITHIN Tableau, telling it that it is a Decimal AND a geographic location. Then, whenever you update you data or replace your data source with similar-schema data, the metadata will remain and you won't have to edit it every time you load it.

CHeers,

Tom
Like Show 0 Likes(0)

Actions
2. Re: Change latitude and longitude with point separator to comma separator

Javier Rubio Jan 8, 2016 11:49 AM (in response to Thomas McCullough)

Thanks Tom,

I have tried but when I change to decimal the number change without taking into account the dot. For example in the Latitude appear 404165 instead of 40.414165 and the latitude in that case is wrong.

But yes the idea is find something within tableau like change . per , or something like that in configuration to accept that parameters.

Regards
Javi
Like Show 0 Likes(0)

Actions
3. Re: Change latitude and longitude with point separator to comma separator

Thomas McCullough Jan 8, 2016 11:50 AM (in response to Javier Rubio)

Try:

FLOAT(REPLACE([Your Latitude Field], ',' , '.'))
1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
4. Re: Change latitude and longitude with point separator to comma separator

Javier Rubio Jan 11, 2016 12:56 PM (in response to Thomas McCullough)

Thanks Thomas, work perfectly, sorry for the delay in the answer I only have access to Tableau in the office.

Regards
Javi
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

Change latitude and longitude with point separator to comma separator

1. Re: Change latitude and longitude with point separator to comma separator

2. Re: Change latitude and longitude with point separator to comma separator

3. Re: Change latitude and longitude with point separator to comma separator

4. Re: Change latitude and longitude with point separator to comma separator

Actions

More Like This