Hi friends, good morning! I would like to know how do I combine two columns, one of date and another of houras in the talend and import into the database the date format time?
Ex: Column DataRef: 11/02/2019 and column hour string: 10:22:03, I would like to save the following column in the db 11/02/2019 10:22:03 ?
Tag as "solved" for others! Kudos to thanks!
This very much depends upon the column types you are combining and the column type you want to output. If they are Strings and you want to output in a String column, you simply need to concatenate using something like this....
row.DateColumn +" " +row.TimeColumn
....in your output column in a tMap.
Otherwise, it might take a little more than that, but it still won't be too difficult.
Sorry for jumping in @fdenis. I started responding before you posted and left the response window while I had a call. Seems like you can handle this one :-)
Hi You can use tJavaRow components and use below logic
output_row.Date = input_row.Date; // it is string datatype
output_row.Hours = input_row.Hours; // it is string datatype
output_row.Date_hours = TalendDate.parseDate("dd/MM/yyyy HH:mm:ss",input_row.Date+" "+input_row.Hours);
and in output oracle use timestamp datatype of your required date .
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Find out how to migrate from one database to another using the Dynamic schema
Learn how to make your data more available, reduce costs and cut your build time
Read about OTTO's experiences with Big Data and Personalized Experiences