TM1 Forum

hi,

whenever i try to upload a .csv file, although the process gets completed but the data is not uploaded correctly. the TI takes the word after comma " , " to the next column, so in that case, my column data are not correct. what should I do ?

talsam wrote:. what should I do ?

Have a look at the settings in the data source tab. Delimiters for fields, the comma separator, thousands separator: all very important when loading text data.

The bottom line is you're going to need to alter the way you are creating the source file to add some other delimiter besides commas. In my experience, making it tab delimited is your best option as you almost never encounter tabs in text data and will never find it in numeric data. If you can't do that then at least have the text data encapsulated inside quotes (") and make sure you don't have any commas inside the numbers.

talsam wrote: what should I do ?

Either change your delimiter or as suggested encapsulate your columns with single quote and in properties change the Quote char = ' and preview your data it should work

Nidhi wrote:

talsam wrote: what should I do ?

Either change your delimiter or as suggested encapsulate your columns with single quote and in properties change the Quote char = ' and preview your data it should work

did that already...

tomok wrote:making it tab delimited is your best option as you almost never encounter tabs in text data and will never find it in numeric data. If you can't do that then at least have the text data encapsulated inside quotes (") and make sure you don't have any commas inside the numbers.

even with a Tab its not wrking..

Please provide screenshots and TI code, to see where the error is.

Did you use AsciiOutput to follow the process closely ?

as Wim suggest: asciioutput helps.

***the TI takes the word after comma " , " to the next column, so in that case, my column data are not correct. what should I do ? - is it string data containing ","?
If string than Tab delimiter and if number than comma delimiter should resolve the issue.

Do following test:

1) save your one excel sheet from the workbook in a text file.
2) Open in the excel and now excel would pop up text import wizard where you can delimit the data. Here try different options to delimit the file and whatever fits in
must be included in the prolog section of the TI process or utilized in TI DataSource section:
DatasourceASCIIDelimiter='Character'

3) If you share the excel file and the code, then we may help you better.

Thanks.