You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
Hello
Only two rows or more rows? Can you give us an example and what are your expected result? So we can give you more precise response.
Best regards
Shong
Offline
Thank for your reply.
The Version of Talend is 4.0
We have some test and NOW is correct… The problem seems a null field…
I begin the definitive job, therefore, explain the process
1.- We have File Delimited and have two rows, one have the date in this format dd/MM/yyyy and the other row have the Time in this format HH:mm and two fields are date Type
2.- We need formatted this values at the format dd/MM/yyyy HH:mm in orther to put in MySql
3.- We change the types of the rows to STRING
4.- We construct a String Data Format like dd/MM/yyyy HH:mm:ss
5.- Use a Variable to cast String to Date (TalendDate.parseDate("dd/MM/yyyy HH:mm:ss",row2.DIA+" " +row2.HORA +":00")) with type Date
6.- Referenced this variable in a MySql fields with type DateTime and it registered correctly.
Sincerely, thanks for your attention.
Best Regards,
JM.
Offline
Pages: 1