Records not rejected from tFileInputDelimited component for MM/dd/yyyy format

[Anonymous]

Hi

I have the following csv file

and job & schema of tFileInputDelimited is

Output after job is run

Problem with job run results is dates are being modified and it gave me different date when compared with actual csv file (please observe last 3 rows in the csv file), and expectation is those records to be rejected and shown under "Rejected Error Records" table in the job run status/console window

I am bit new to Talend, could you please let me know how this can be fixed, and show those records to be  appeared under "Rejected Error Records" category.

[manodwhb]

If you have other format data value against with that column,entire record will be rejected.

[Anonymous]

@manodwhb 

Some data in HIREDATE and DOJ columns in CSV file is not as per the defined format,

HIREDATE schema format is dd/MM/yyyy, invalid data values passed to this column are 2/20/1981 (Row2 in CSV, month value is invalid), 42/1/2020 (Row6 in CSV, date value is invalid) which are good candidates for rejection

DOJ format is dd-MM-yyyy, and values passed to this column are 35-05-2020 (Row4 in CSV, date value is invalid)  and 4-44-2020 (Row6 in CSV, month value is invalid) which are good candidates for rejection.

[Anonymous]

@manodwhb

Hope it is resolved by checking an option i.e. Check Date in Advanced settings of tFileInputDelimited component

Below is the job run results

[manodwhb]

@uganesh , by enabling the check date in advanced setting you will get the other formats data into rejected flow.