Solved! Go to Solution.
Using this. But all data going to error Table Now.
TalendDate.isDate(row1.MONTH_OF_DATE,"MM/dd/yyyy",true). Data is in MM/dd/yyyy
Please find it
Top 3 should go to Normal and Below One 2016/22/35 should go to error. Input coming to tmap is String and converting that to Date using TalendDate.parseDate("MM/dd/yyyy",row1.MONTH_OF_DATE).
This is the Boolean Variable Port condition for seggregating data
I inserted 35/2017/22 this record in my file. It went to reject. But going there It converted to something like this 5/10/0030. I am taking My date Column to tmap Pass and ERROR Table of Output and converting there using TalendDate.parseDate("MM/dd/yyyy",row1.MONTH_OF_DATE). Snapshots attached
Are you trying to convert invalid dates to specific format?
If yes, that is not going to work because you don't know the format input value coming.
Please let us know you exact requirement.
Yess You were right. I was trying to convert Invalid Date to Right Format which was causing Issue. Changing Datatype to String in Error Table and dragging from Input Date Column to ERROR Table DateColumn Port of tmap resolved my Issue. Marking the Post as resolved.
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.