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.
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.