reject output of tschemacompliance not working - TOS 6

[Anonymous]

Hi
Here is my job
http://prntscr.com/9k7q67
Reading a file having records 26586, one record is broken i.e date format is wrong as required.
26585 processed properly and 1 rejected but couldn't show up in output like tlogrow.
Any Help ?

[Anonymous]

Hi xdshi
I have tried with string as well. But When I use string for date column, tschemacompliancecheck rejects all 26586 records.
Can you see what's the matter ?

[Anonymous]

Here is my component properties
http://prntscr.com/9m8if1
http://prntscr.com/9m8idd
http://prntscr.com/9m8iaa

[Anonymous]

Hi,
Could you please also show us your tSchemaCompliance component setting?
We made a simple testing on this component, everything is going well on our side.
For example,
My input:
sabrina;L;05/11/2016
dan;M;2016/11/04
I want to get the rejected input row which is against date pattern "MM/dd/yyyy".
Please see my screenshots for details
Best regards
Sabrina

[Anonymous]

Hi  xdshi,
The tSchemaCompliance component setting u showed even i tried it is working fine .It works with ouput as tlogrow .But it fails in case where output is DB .my scenario is i want to upload a vaild data into table from CSV while rejecting invalid data parking separtely in file or table for error.
Attaching my component settings .With this the records with invalid DATE  also gets uploaded which actually should be rejected.

[vidya821]

Hi @xdshi,

I am facing an issue with the Incorrect input error which is not flown to LogRow or an output file.

Error is displayed in console.

My aim is to find out the specific column name which has this issue.

Pls help

Thanks

Vidya

SchemaComplianceCheck.png