COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: tamise on 19 Apr 2014 12:40:19 PM

Title: Definition File - csv
Post by: tamise on 19 Apr 2014 12:40:19 PM
Hello,

I want to load a table with CSV  file so i used a definition (.def) file.
In my csv file, I have a column AMOUNT ( -1 256 895).
And in my def file a put AMOUNT NUMBER 33.5 . I got a error message invalid number.

Can you please help me ?

Thanks.
Title: Re: Definition File - csv
Post by: rih9000 on 20 Apr 2014 07:21:47 AM
I would (in the CSV file) change the spaces to the null character.
rih9000
8)
Title: Re: Definition File - csv
Post by: tamise on 20 Apr 2014 08:40:38 AM
Si do you mean that i have to put -1256895 instread of  -1 256 895.
It is working but is there another solution?
Title: Re: Definition File - csv
Post by: rih9000 on 20 Apr 2014 11:18:57 AM
Hi, I can't think of another solution,
rih9000