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.
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.
1 of 1 people found this helpful
FLOAT(REPLACE([Your Latitude Field], ',' , '.'))
Thanks Thomas, work perfectly, sorry for the delay in the answer I only have access to Tableau in the office.