Talend excel out not as expected

[Anonymous]

Hi,

Please can you help me with below request.

eg :

input :

item            netmass

tea               0.0001

Output:

item            netmass

tea               0.0001

For some reason the output is coming as 0 instead 0.0001. how do i get 0.0001 instead 0.

thanks for your help.

Regards,

Vinay

[TRF]

Probably you just have to change the number of digits after the decimal point for this column when you open the Excel file.
To be sure, add a tLogRow before the tFileOutputExcel or replace it by a tFileOutputDelimited.