You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » tSchemaComplianceChecker - Validate Null Date
#1 2007-12-12 01:34:10
- Michael C
- New member
- Registered: 2007-11-23
- Posts: 7
tSchemaComplianceChecker - Validate Null Date
Can somebody confirm if the [Bugtracker, bug 2417, fixed] SchemaComplianceChecker - typeCheck on null values and customizable dateformat 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
Offline
#2 2007-12-12 09:51:11
Re: tSchemaComplianceChecker - Validate Null Date
Hi
About [Bugtracker, bug 2417, fixed] SchemaComplianceChecker - typeCheck on null values and customizable dateformat, 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
Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!
Offline
#3 2007-12-13 23:14:37
- Michael C
- New member
- Registered: 2007-11-23
- Posts: 7
Re: tSchemaComplianceChecker - Validate Null Date
shong wrote:
Hi
About [Bugtracker, bug 2417, fixed] SchemaComplianceChecker - typeCheck on null values and customizable dateformat, 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.
Last edited by Michael C (2007-12-13 23:15:17)
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » tSchemaComplianceChecker - Validate Null Date