Input and output field is string(50), its a date field, but uses string type.
In my input data, blanks are coming in this date field and it needs to be passed to output.
I have used below code in tMap but it didn't worked. Please help to resolve this issue.
row2.DiagnosisActivityStartDate == "" ? "" : TalendDate.formatDate("MM-dd-yyyy",TalendDate.parseDate("yyyy-MM-dd",row2.DiagnosisActivityStartDate))
Solved! Go to Solution.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema