How to convert string to date format!

Anonymous · ‎2011-10-10

Hi Talend Support officer,
Can you tell me how can I convert the string data of "14/09/2001" from MS Access to DB2 date format ("yyyy-mm-dd") as "2001-09-14" by using tMap function in Talend Open Studio, please?
Thanks.
Regards,
KM

Anonymous · ‎2014-01-30

Hi remytom,
Thank you for your reply ,i got a proper result.

Anonymous · ‎2014-02-04

Hi anyone can help me how to solve this problem...........

I have a date in my Excel file is 01-JAN-06. 01 represents the day of the week, JAN represents the month and 06 represents the year. The Excel file also contains date values of 00-XXX-00 which represent no date. For example a column containing last purchase date data would look like this:"DateOfLastOrder"
"01-JAN-06"
"02-JAN-06"
"00-XXX-00"
"03-DEC-05"The value of 00-XXX-00 means that there is no purchase date.I want to bring these columns into my table and replace the 00-XXX-00 values with a NULL.
The table of tmssqloutput Data Type is datetime.

Anonymous · ‎2014-02-04

Hi anyone can help me how to solve this problem...........

I have a date in my Excel file is 01-JAN-06. 01 represents the day of the week, JAN represents the month and 06 represents the year. The Excel file also contains date values of 00-XXX-00 which represent no date. For example a column containing last purchase date data would look like this:"DateOfLastOrder"
"01-JAN-06"
"02-JAN-06"
"00-XXX-00"
"03-DEC-05"The value of 00-XXX-00 means that there is no purchase date.I want to bring these columns into my table and replace the 00-XXX-00 values with a NULL.
The table of tmssqloutput Data Type is datetime.
This is the error iam getting: only the date between january 1 1753 and december 31 9999 are accepted .

Anonymous · ‎2014-02-05

This code could help for the replacement. This is used in tjavarow component after the file is read.
if (TalendDate.isDate(input_row.HD,"dd-MM-yyyy") == true)
output_row.HD = TalendDate.parseDate("dd-MM-yyyy",input_row.HD);
else
output_row.HD = null;

Anonymous · ‎2014-02-13

Hi, any one can provide me one snapshot for joblet with example, because i am confusing with schema while creating joblet in talend enterprise edition.
here i am doing concatinating fname+lastname=full name in variable tmap
Here i have used schema for emp table for joblet and how can i use this for another job .............
In another job i have customer table.............

Anonymous · ‎2014-02-13

Hi mahadevank,
Have you ever checked the document TalendHelpCenter

esigning+a+Joblet.
Best regards
Sabrina

Anonymous · ‎2014-02-13

Hi, Yes already i have studied talend help centre about joblet but i can't understand...........
In my job i have a source like this....... emp table
empid firstname lastname gender maritalstatus dob
here i created joblet with tmap,sorter,filter
joblet.................
INPUT(emptable)-tmap-sorter-filter-OUTPUT.
joblet mean> reuse this transformation logic for multiple job.
But here i used emp table from INPUT to OUTPUT with all the above mentioned component in joblet.
so if i want to use this joblet for another job means i have to use this only for emp table as a source not for another table as a source in this job.
My question is:
1. So what is the use for joblet........... when i have a customer table with the following columns
customerid firstname lastname city phoneno email in a job (here how to use that joblet)
2. And In talend help center they created one joblet for one source and they used this joblet in another job without mentioning the source of a job. whether it is same source or different.
If it is same what is the use of it..........
3. I need one example joblet and one job using (that joblet) to understand with schema for both.

Anonymous · ‎2014-03-03

Hi any one can help me to solve this issue
I have a source in excel like id name date
10 Ravi 18/05/2014
20 Naraine 06/12/2013
30 Mahesh 23/10/2012
40 Ganesh 09/10/2010
Note :
Now i want to load the entire rows of data in to tmssqloutput, but iam getting only the rows which in MM/dd/ yyyy format in source.
Because its considering the source in MM/dd/yyyy format , so i got only the rows which is less than 12 month like 09/10/2010 and 06/12/2013.

But i entered the rows in excel in the meaning of dd/MM/yyyy............... if i used parsed date fuction in tmap i got all the rows. this is only ok for tlogrow but not for tmssqloutput.
if i used tmssqloutput i got this error...... only the date between january 1 1753 and december 31 9999 are accepted. Any solution for this..............

Anonymous · ‎2014-03-04

Hi mahadevank,

But i entered the rows in excel in the meaning of dd/MM/yyyy............... if i used parsed date fuction in tmap i got all the rows. this is only ok for tlogrow but not for tmssqloutput.

How did you parsed date fuction in tmap? What the error looks like? Data truncation?
Best regards
Sabrina

Anonymous · ‎2014-03-04

Hi thanks for your response..................Here i explainde my job and error, which i got.
JOB: tFileInputExcel- tmap- tmssqloutput
1. if i used Date column with date datatype in tfileinputexcel, i got only few rows like which i said on previous post and my error is "The cell format is not Date in row 1 and column 4
"The cell format is not Date in row 3 and column 4.
2. If i used Date column with string datatype in tfileinputexcel , i did not get any row in tmssqloutput
Tfileinputecxel(Date date)-tmap output as date datatype. error is Only dates between January 1, 1753 and December 31, 9999 are accepted.
My expectation is , i want to load all the rows of data into tmssqloutput.........

Other

Talend Data Integration