Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a scenario in which data present in emp_dept.csv file should be split and inserted into two respective tables(EMP,DEPT)
Actually there is a field DOB declared as string in input schema(.csv file) but in EMP table the same column declared as date.
I tried with tMap TalendDate.formatting function also but getting the following error.
Type mismatch: cannot convert string to date.
Can somebody help me to overcome the situation.
Thanks
Babu Chokka
Hi, in this format
TalendDate.parseDate("dd/MM/yyyy",row1.DOB(input schema column name))
can you please what to substitute in place of input schema