-
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
-
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
-
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)1 of 1 people found this helpfulTry:
FLOAT(REPLACE([Your Latitude Field], ',' , '.'))
-
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