Talend excel out not as expected

Five Stars

Talend excel out not as expected



Please can you help me with below request.


eg :

input :

item            netmass

tea               0.0001



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.





Fifteen Stars TRF
Fifteen 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.


Cloud Free Trial

Try Talend Cloud free for 30 days.


Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.