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.
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Accelerate your data lake projects with an agile approach