Forum Discussion
Decimal separator missing when importing data
The solution in the end had to do with how I import my data. My organisation uses an Oracle Database (a very old 32 bit version), and when getting data, I would select "ODBC" which would then result in the issue of missing decimals.
The solution in the end was simply to select "Oracle database" when importing data. No issues followed after that.
Hello, I imagine you have already solved the problem, however, for people looking for an answer to this dilemma, what worked for me was to consult the values that do not appear correctly, add the function To_number (column) and in this way identify it as a number.
I hope it works for you.
The solution in the end had to do with how I import my data. My organisation uses an Oracle Database (a very old 32 bit version), and when getting data, I would select "ODBC" which would then result in the issue of missing decimals.
The solution in the end was simply to select "Oracle database" when importing data. No issues followed after that.