The Definitive Guide to Data Quality
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.
Join us live for a sneak peek!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.