I am trying to convert a date format from yyyy/mm/dd to MMM-YY. E.g., if the date in the input excel is 2019/01/01 then I want the output as JAN-19 and I have used TalendDate.formatDate("MMM-yy",row28.Start_Date) in the Variable and StringHandling.UPCASE(Var.var1) in the expression .
The input file is excel and the Type is Date "YYYY/mm/DD". For the output format I am changing it to String in variable and string in output excel. I am getting null pointer exceptions about Dateformat so I tried to add row28.Start_Date==null?null:TalendDate.formatDate("MMM-yy",row28.Start_Date) .
It is running without errors but now it is returning only blank for that oarticular column.
any help will be greatly appreciated.. Thanks
Solved! Go to Solution.
Thanks for the reply.
I would be using that column to map other columns in the output so I dont think I can change the dateformat because it will affect other column data.
possible it some mistake somewhere, because it work as expected:
[statistics] connecting to socket on port 3784 [statistics] connected .----------. |tLogRow_1 | |=--------=| |Start_Date| |=--------=| |Jan-19 | |null | '----------' [statistics] disconnected
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.