Post a reply

Write your message and submit

Options

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

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

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 08:12:03

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.

Board footer

Powered by FluxBB