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.
Joachim2108 I would try to bring the column in as text, then replace the commas with periods, and then change the type back to decimal in the transform data screen. You may need to go up the applied steps a bit to before it intitally tries to change to to a decimal.
Hi DataZoe,
The issue is that I can see this in the preview window before loading the data, that there is no decimal separator at all. So when transforming the data, there is no comma or period to replace unfortunately.