• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » [resolved] HELP - Merge date & Time

#1 2010-03-08 17:03:46

jmunoz
New member
Registered: 2010-03-08
Posts: 2

[resolved] HELP - Merge date & Time

Tags: [date, merge, parse]

Hello,

I am new and we need some help.

We have two rows, one with date (08/03/2010)  and other with time (08:45).

We need merge Date and Time in one field. We have some test and we do not have a correct result.

Some idea, please.

JM.

Offline

#2 2010-03-09 04:10:00

shong
Talend team
Registered: 2007-08-29
Posts: 10357
Website

Re: [resolved] HELP - Merge date & Time

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


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

#3 2010-03-09 10:31:42

jmunoz
New member
Registered: 2010-03-08
Posts: 2

Re: [resolved] HELP - Merge date & Time

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

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » [resolved] HELP - Merge date & Time

Board footer

Powered by FluxBB