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.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables