Loading files with different decimal separator

Document created by alexanderkappes Employee on Mar 1, 2018
Version 1Show Document
  • View in full screen mode

Hi,

sometimes it can happen, that you have to load files into your database which are delivered with different decimal separators or in general files coded on machines with different regional settings.

 

For example in Germany we use "," as decimal sign and "." as thousands separator.

 

Now other countries (much English speaking ones) use the signs in reverse ("," as thousands separator and "." for decimals).

 

How to easily load such files into BOARD should been shown within this Inspiration.

Initially I loaded the file into Text Cube and transformed the decimal separator from "." to "," with ETL.

 

Finally I performed a little DataFlow which transfered the Data into the real figures target cube.

You will find the sample attached which was created on BOARD 10.1.4.50129 and can be customized depending to your configuration.

 

Perhaps it can help somebody.

 

Kind regards

 

Alexander Kappes

10 people found this helpful

Outcomes