topic Talend excel out not as expected in Talend Studio

Talend excel out not as expected

Anonymous — Sun, 22 Apr 2018 00:35:09 GMT

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

Re: Talend excel out not as expected

TRF — Sun, 22 Apr 2018 07:58:40 GMT

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.