Issue in date cell of excel

Highlighted
Eight Stars

Issue in date cell of excel

My formula is not getting calculated in my excel output due to cell format issue. Please see the attached, Talend is generating the output in excel in which the date cell is having the format as "GENERAL" whereas if i changed the format to "Custom" (see the attached) then its working fine. 

 

Please suggest how to populate the result in excel with this ("Custom") format.


Accepted Solutions
Moderator

Re: Issue in date cell of excel

Hello,

Could you please have a look at custom components- tFileExcel components provided by Jan Lolling's to see if it is what you are looking for?

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.

All Replies
Moderator

Re: Issue in date cell of excel

Hello,

Could you please have a look at custom components- tFileExcel components provided by Jan Lolling's to see if it is what you are looking for?

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.
Eight Stars

Re: Issue in date cell of excel

Its resolved already. Thanks Sab

Moderator

Re: Issue in date cell of excel

Hello,

Would you mind sharing your solution on forum?

Thanks for your time.

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.
Eight Stars

Re: Issue in date cell of excel

I added 2 tMap's

 

Input-->tMap-->tMap-->OutputExcel

 

In first tMap, i changed the Date format from "YYYY-MM-DD" to "MM-DD-YYYY"

 

In second tMap, i changed the datatype from "Date" to "String" and it worked.

 

When i changed the Date format and the Datatype in 1st tMap alone, then i was getting error saying "Cant convert Date to String"

Moderator

Re: Issue in date cell of excel

Hello,

Here is a built-in method in talend.

TalendDate.parseDate("yyyy-MM-dd",TalendDate.formatDate("dd/MM/yyyy")).

It will analyses the string as a date and then format the result in new one.

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.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

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