Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
"".equals(row2.DiagnosisActivityStartDate) ||
row2.DiagnosisActivityStartDate == null ? "" : TalendDate.formatDate("MM-dd-yyyy",TalendDate.parseDate("yyyy-MM-dd",row2.DiagnosisActivityStartDate))
"".equals(row2.DiagnosisActivityStartDate) ||
row2.DiagnosisActivityStartDate == null ? "" : TalendDate.formatDate("MM-dd-yyyy",TalendDate.parseDate("yyyy-MM-dd",row2.DiagnosisActivityStartDate))
WOwwwww TRF... it worked. Thank you very much again