Excel Date value differs in Generation Mode

Five Stars

Excel Date value differs in Generation Mode

Hello,

I am reading date column and also a custom format date column value from excel as String and I get different values based on the generation mode I select. 

Can someone help me with, what is the proper way to read date column? I understand the usage of TalendDate::format() and parse() methods. 

I am processing a large excel file, so the generation mode has to be event mode.

I have attached sample excel file, job is very simple and all columns are read as string

tReadFileExcel  ------->  tLogRow

I am using DI 6.3.1

Moderator

Re: Excel Date value differs in Generation Mode

Hi,

Do you want to convert your Date type to String type in work flow? What does your expected result look like?

More information will be helpful for us to understand your requirement.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Excel Date value differs in Generation Mode

Hello Sabrina,

I would like to have it as String in M/d/yyyy format and also would like to understand why the values are different from what is shown in Excel and in Talend.

 

Thanks

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

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

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now