I want to put some condition in my tMap.
I have a tiFileInuptDelimited->tMap ->tPostgresqlOutput (my database is Postgres).
All my column in my File are string and I want to put some condition in my tMap to put my data in my table with Integer, Char, Date, etc....
So for the Date, I have a regex expression in my condition and in the expression of my field I am using TalendDate.parseDate ("dd/MM/yyyy", row1.date). So it works when my data of my File is not empty because othwersie it doesn't work.
I tried to put another condition (String.valueOf(row1.date).equals("")) but i have still the same error message:
Caused by: java.text.ParseException: Unparseable date: ""
... 3 more
I also have tried to put String.valueOf(row1;date)==null and i don't have an error but that doesn't go to the database.....
And i have the same rpoblem when i want to parse the String in an Integer....
thank you for your help
if it is equal to 'W' to women, if it is equal to "M" to "Man", and if it is not W or M, to "Undefined"
Could you help me please?
Start a job SujetDuStage 08/09/2011 10:03.
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
Introduction to Talend Open Studio for Data Integration.