topic Re: Records not rejected from tFileInputDelimited component for MM/dd/yyyy format in Talend Studio

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

Anonymous — Tue, 05 May 2020 18:49:59 GMT

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.

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

manodwhb — Wed, 06 May 2020 04:30:12 GMT

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

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

Anonymous — Fri, 08 May 2020 08:44:23 GMT

@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.

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

Anonymous — Fri, 08 May 2020 10:21:47 GMT

@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

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

manodwhb — Fri, 08 May 2020 10:44:19 GMT

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