tSchemaComplianceChecker - Validate Null Date

One Star

tSchemaComplianceChecker - Validate Null Date

Can somebody confirm if the 2417 addresses validating a null date column from a tFileInputPositional?
Currently I cannot read in a blank column defined as a string and check for compliance using another schema where the column is defined as a date and is nullable (see attached screenshot). The record will always be rejected since the column is always converted to a date regardless of the nullable flag.
Using Java
Talend Open Studio
Version: 2.2.1
Build id: r6584-20071031-1227
Highlighted
Community Manager

Re: tSchemaComplianceChecker - Validate Null Date

Hi
About 2417, We are handling it.
The record will always be rejected since the column is always converted to a date regardless of the nullable flag.

You can't use a date pattern"dd-MM-yyyy" to check an null String, so it will be rejected.
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: tSchemaComplianceChecker - Validate Null Date

Hi
About 2417, We are handling it.
The record will always be rejected since the column is always converted to a date regardless of the nullable flag.

You can't use a date pattern"dd-MM-yyyy" to check an null String, so it will be rejected.
Best regards

shong

It will be great when the bug fix is release however it currently is set to low priority. What does this mean in regards to the the release date?
My workaround right now is to fill in blank dates columns with a dummy data (e.g. 19000101) and then strip out the dates after the schema compliance check. Not very pretty when you have many dates in many different files.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now