Talend excel out not as expected

Five Stars

Talend excel out not as expected

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

 

Forteen Stars TRF
Forteen Stars

Re: Talend excel out not as expected

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.

TRF