I use Postgres database to my latitude and longitude data, but its in string format, so I change the Data Type to Decimal using tableau but somehow I've got Error. but if I use mysql database with the same string format, and I convert it using tableau it works fine. although the data is contain a character like letter or space, it will convert into zero value. But in Postgres I got this error.
how can I Fix this? cause I want to use Postgres as my database. Please Help...
Looks like there's no easy way out of this and you'd have to use Custom SQL and clean your fields up a little.
See here for ways you can convert these sort of strings in Postgres: sql - How do I cast a string to integer and have 0 in case of error in the cast with PostgreSQL? - Stack Overflow