Talend community forum / help needed

antojj_87 · 2008-12-22 08:12:03

Tags: [database, date, db2, delimited file, deployment, development, error, error management, mssql, sybase, tos3.0.0]

Hi friends,

I want to data validation and then insert into database. how can i separate a row from excel and check for it's data type reply asap.

cantoine · 2008-12-22 11:45:20

Hi,

You have several ways to do that.

Firstable to parse your Excel file use the tFileExcelInput, then you have capability to format your row into a tMap (processing category), then you can check dataQuality or specificities with a tSchemaComplianceCheck or using routines.

Please refer to the demoProject (embedded in the studio) or download Documentation.

Best regards;

antojj_87 · 2008-12-22 12:45:21

thanks for the help cantoine but i want to check for the data type of each row and if rejects i should display it as an error entry

Announcement

Unanswered posts

#1 2008-12-22 08:12:03

help needed

#2 2008-12-22 11:45:20

Re: help needed

#3 2008-12-22 12:45:21

Re: help needed

Board footer