You are not logged in.
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
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.
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.