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 .
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Read about OTTO's experiences with Big Data and Personalized Experiences
Pick up some tips and tricks with Context Variables
Take a look at this video about Talend Integration with Databricks