Loading files with different decimal separator

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


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 and can be customized depending to your configuration.


Perhaps it can help somebody.


Kind regards


Alexander Kappes

10 people found this helpful