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|||W| Can somebody help me out
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
