I am creating a job where below is the job flow
tRestClient->tExtractXMLField ->tXMLMap ->tMongoOutput
I am having an input date as shown below and please tell me how can i output in the ISODATE format
input date format -> 2006-10-05 14:34:58
expected output date format -> ISODate("2016-07-14T00:00:00.000+0000")
I don't understand why you use tXMLMap component in your job, I think you just a tMap to do some transformation. Try to parse the string to a Date with this expression on tMap:
TalendDate.parseDate("yyyy-MM-dd HH:mm:ss", row1.columnName)
In the output table, select 'Date' type for this column and set its date pattern as "yyyy-MM-dd'T'HH:mm:ssZ"
Let me know if it works.
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the global leader of open source data management and application integration solutions!