You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2013-06-14 12:58:08

rishi_b09
Member
3 posts

rishi_b09 said:

issues with date format

hii all,
I am using talend MDM v5.2.2 with java
i am trying to fetch data(date column) from excel file.
date format is "DD/MM/YYYY". I converted it to" YYYY-MM-DD" using tjavarow. Now i want to insert this record in a table on MDM server.

texcelFile--> tjavarow-->tlogrow1-->tmap-->tlogrow2-->tmdmoutput

format is properly shown in tjavarow but in tlogrow1 it changes

eg:

Destination Date : 2013-07-08

2013-07-189|MY|MY-02|W
Destination Date : 2013-07-09

2013-07-190|MY|MY-02|H
Destination Date : 2013-07-10

2013-07-191|MY|MY-02|W
Destination Date : 2013-07-11

2013-07-192|MY|MY-02|W
Destination Date : 2013-07-12

2013-07-193|MY|MY-02|W
Destination Date : 2013-07-13
2013-07-194|MY|MY-02|W
Destination Date : 2013-07-14
2013-07-195|MY|MY-02|W
Destination Date : 2013-07-15

2013-07-196|MY|MY-02|W
Destination Date : 2013-07-16
10000013|2013-01-15|[MY]|[MY-09]|W|

Can somebody help me out

Offline

#2 2013-06-15 17:18:13

brazabr
Member
30 posts

brazabr said:

Re: issues with date format

Hi,

Check the Pattern in the schema of the input component that reads the Excel file. If you set the proper format there, you don't need to convert strings. The date will be loaded a Date object.

Can you send some screenshots, specially the input schema window? Also some sample of the input data will help you get some answers.

Regards,
Thiago

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy