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 ?
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
