Talend excel out not as expected

Highlighted
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

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

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.