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

 

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.

TRF

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch