Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
151
Views
1
Comments

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. 

Questions:

  1. Any ideas how to solve this issue (apart from modifying the CSV file)?
  2. The issue would not appear if we would be able to specify not only the column-delimiter (this is possible) but also the decimal separator. Is this on the roadmap?

Version

DV Desktop 12.2.5.1.0

Tagged:

Answers

  • RichardChan
    RichardChan Rank 6 - Analytics Lead

    probably need to preprocess that column, can use unix sed  for example