Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Error when importing CSV files separated by semicolon and decimal separator colon — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Error when importing CSV files separated by semicolon and decimal separator colon

Received Response
10
Views
1
Comments
edited Sep 11, 2019 5:22AM in Oracle Analytics 1 comment

Summary

Error when importing CSV files separated by semicolon and decimal separator colon

Content

A customer is getting data from an external provider in the following format: 

  • CSV file with semicolon as column-delimiter and comma as decimal separator

Issue description:
1. When importing as new data set within DV the column-delimiter will be recognized correctly.
2. But the import fails to recognize the comma as decimal separator. Therefore this column will be treated as “attribute” and text field.
3. Changing the properties later does not help. I can change to “measure”, “number” and set aggregation to “sum”.
4. But the result will be that all decimal places will be lost and replaced by zeros (e.g. 156,34 will be replaced by 156,00). Or it may happen that the column remains empty. 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!