I have an error that i don't unterstand :
I did : a fileInputExcel => tMap => tfileOutputExcel.
I wanted retrieve a column with pourcentages (with a single line to unterstand the error : header : 5 Limit : 1)
Then, in tMap, I put Pourcentage in String because in log console, it indicates the error For input : String. At the beginning, I put in Double and also in Float.
I run the job :
Normally, I should have : 0,47 (or 0,468). From where goes out 4.475? 4.7? 0.8?
There is a single line....
Thanks in advance !
Solved! Go to Solution.
This is my consol log :
We can see "0" in tLogRow, but it isn't possible.....
Little information : My excel file was in format xlsb and i save the same file in format xlsx. I hope that the matter isn't from that format xlsb to xlsx. Talend can't read the format xlsb.
@Beauchamp_J,without tmap connect from tFileInput excel-->tLogRow,and check is this working?
Forgive my previous post and read here.
So, i take the file with all columns and Talend only keep 0.0% but not the others.
(Dupont Adele, Tintin Amerique, David Xavier, Vin Rouge aren't in the console log (for input string))
I show that to you :
I have a suspicion that your system settings are wrong for the data you are working with.
Can you run this code in a tJava in a blank Talend job and show us what you get?....
java.text.DecimalFormat decFormat = new java.text.DecimalFormat(); java.text.DecimalFormatSymbols decSymbols = decFormat.getDecimalFormatSymbols(); System.out.println("Decimal separator is : " + decSymbols.getDecimalSeparator()); System.out.println("Thousands separator is : " + decSymbols.getGroupingSeparator());
You are right. i check in advanced settings on the fileinputexcel :
Thousands Separator : ""
Decimal Separator : "." instead of ",".
And i put all columns in string
And Bingo ! It works!