topic How to pass blank date to output in Talend Studio

How to pass blank date to output

Anonymous — Wed, 09 May 2018 09:54:09 GMT

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))

Re: How to pass blank date to output

TRF — Wed, 09 May 2018 09:57:55 GMT

"".equals(row2.DiagnosisActivityStartDate) || 
row2.DiagnosisActivityStartDate == null ? "" : TalendDate.formatDate("MM-dd-yyyy",TalendDate.parseDate("yyyy-MM-dd",row2.DiagnosisActivityStartDate))

Re: How to pass blank date to output

Anonymous — Wed, 09 May 2018 10:20:07 GMT

WOwwwww TRF... it worked. Thank you very much again