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!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema