I am getting "Unparseable date" error by using the below code.
"".equals(ColName) || ColName == null ? "" : TalendDate.formatDate("yyyy-MM-dd",TalendDate.parseDate("MM-dd-yyyy","ColName"))
Input is "Date" type, i am converting it to String type. I am also trying to replace null with blank values
Solved! Go to Solution.
@samisyed80,what is the source date format? do you just need to convert date to string?
@samisyed80,to convert date from one format to another use below way. are you loading to excel file out it doesnt matter sting or date
@samisyed80,sorry,previous worng screenshot.
find teh correct one.
@samisyed80,use this way
"".equals(ColName) || ColName == null ? "" : ColName
try the below one.
@samisyed80,still do you have issue?
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.