tschemacompliance not working as it does

Anonymous — Wed, 30 Dec 2015 07:47:13 GMT

Hi
I have some csv files in one folder. Some have date format "13/09/2015" and some having date format "2015-09-13". I need "13/09/2015" to be passed and rest rejected.

In tfileinputdelimited, I have set up the date column as string. Because I dont know in which file what would be the date format. But right format is "dd/MM/yyyy".

In tschemacompliance, in custom field define set up date column with the date format "dd/MM/yyyy" and date datatype.

There is one file and having 100 records. Only one record having date column with date format "yyyy-MM-dd" and rest 99 records are ok with date format am looking for "dd/MM/yyyy"

Instead of rejecting only one record, its rejecting all records.

Here is the job flow

tfilelist--->tfileinputdelimited---->tschemacompliance-----reject---->tmap----mysqldb
in tmap...input and output date columns are defined as string.
can anyone help me ?

Re: tschemacompliance not working as it does

Anonymous — Thu, 31 Dec 2015 03:27:14 GMT

Hi,
We have replied your another topic: thread. Could you please take a look at it?
Please stick to one topic so that we can pay individule attention to your issue.
Best regards
Sabrina

topic Re: tschemacompliance not working as it does in Talend Studio

tschemacompliance not working as it does

Re: tschemacompliance not working as it does