How to import data with comma into a single column

Chonpat Laymanuman

Dear All

 

Would you please advise?

 

I have received the feedback from Board vendor that Board BI can not import data with comma into a single column.

It seems that it is the technical constraint from Board technology.

 

Let me explain more and give you the case we face as the following :

 

We are using the Board BI version 10.1.3 and We have extracted data from SAP with CSV data file where values may have comma as part of value. Our column separated delimiter is set "|"  as pipe delimiter.

 

 for example

We import this 10,000 value from CSV data file into Board BI

It seems Board BI  recognizes that data which contain comma value, it is separated by comma automatically  So data is presented as 10 instead of 10,000.

 

We are not sure Is this the technical constraint ?

Daniele Di Lorenzo

Check data reader settings

if the file is a csv "|" delimited you have to set  the correct separator in the ascii data reader setup and the nr 10,000 will be correctly recognized.

 

Also be sure that the server settings are consistent, with the comma set as decimal separator.

Chonpat Laymanuman

Hello

 

Thanks a lot for you advise, I have asked our vendor to try your solution but it does not work properly.

Let's see attached picture and kindly further advise

Daniele Di Lorenzo

Which is the default dec separator in server settings where Board is installed?

Chonpat Laymanuman

please see our step above : we have set "|" as defaults separator in regional setting in our server.

It seems it does not work, we are not sure what step we are missing , please advise.

Daniele Di Lorenzo

sorry, maybe I was not clear

 

you have to check the decimal separator setting

 

if comma is ok, figures should be uploaded correctly

 

if dot it's normal that when you read a file with comma as separator it's not recognized