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
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
Practical steps to developing your data integration strategy.