Error with Format Pourcentage from Excel to Number in new Excel

[Anonymous]

Hello, 

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 ! 

[manodwhb]

@Beauchamp_J, are you looking for the following?

[Anonymous]

@manodwhb

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.

[manodwhb]

@Beauchamp_J,can you write to tlogrow from tExcelfileinput?

[Anonymous]

@manodwhb

Write to tlogrow from tExcelfileinput? Sorry, i don't undestand....

[manodwhb]

@Beauchamp_J,without tmap connect from tFileInput excel-->tLogRow,and check is this working?

[Anonymous]

It works. Not an error.

It is the tMap which raised a problem. Why?

[manodwhb]

@Beauchamp_J,can you post tmap settings.

[manodwhb]

@Beauchamp_J,use below way in tmap

[Anonymous]

@manodwhb

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 :