topic Re: Talend not verifying null checks on date columns in Talend Studio

Talend not verifying null checks on date columns

Anonymous — Sat, 16 Nov 2024 05:12:29 GMT

tFileInputDelimited date data type columns are not checked for schemacompliance!

In the Talend job I am reading an input file with 15 columns data and in that there are 3 date columns, I have unchecked the null check box for these date columns, but still in the input if the date columns are null it is processing with out sending it into the reject order file, but the same is working with string data types when they are null and when null check is disabled those records are sent into the reject order file.

Tried with tSchemaCompliance component as well, not considering null on the date columns.

It is a simple and basic requirement on the date columns and that is not working!!

Re: Talend not verifying null checks on date columns

Anonymous — Mon, 22 Jul 2019 14:59:34 GMT

Hi,

Its working fine for me. Please refer the screenshots below.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Talend not verifying null checks on date columns

Anonymous — Tue, 23 Jul 2019 06:42:38 GMT

With tFileInputDelimited Reject order, disabling the null check on the date field is not working, that way can we get the error on the date fileds when they are null? Also is it possible to show multi errors from a single row, like if I have 8 fields out of that 2/3 fields are not compliant with the schema definitions can we show all the errors in the error Message instead of the first field error alone?

Re: Talend not verifying null checks on date columns

Anonymous — Tue, 23 Jul 2019 20:42:15 GMT

Hi,

For null check, you can always depend on tMap by adding a Relational ISNULL function.

Regarding your second query, you will have to raise it as a feature request in Talend JIRA.

https://jira.talendforge.org

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂