You are not logged in.
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.
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.