I imported data with Blendo from a google sheet. In Germany, we separate decimals with a comma and not with a period. For example, instead of three and a half being
3.5 we write it as
I think that the database does not recognize my decimal numbers because it’s expecting periods but receiving commas. The fields are saved in the data warehouse as text strings, which means we can’t use sum functions and other numeric operations.
What can I do to fix this situation?