Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to capture rejected records .

Hi All,
As per my business need I need to capture from the Inputfile tfileinputExcel -- > actual(correct ) records along with count and rejected records along with count .
I tried using Main link and rejected link  of tfileinputexcel component but ( rejected link is not capturing all rejected data , its only capturing rejected column information .
For ex :In my input If I have 5 column and If First column has error records in the error message its only giving information about 1st column , rest all blank . and if we have error in 3 rd column first two column information and error record information it is showing 4 and 5 getting displayed has null and so on .

BUt My requirement is capture all the error record along with count and send the file back to client for there confirmation and reprocess it .

Please help me how can I implement this logic
I need to caputure all the column (row information) information along with count .
thanks
Mohini

Labels (2)
4 Replies
Anonymous
Not applicable
Author

Hi,
Here is a component TalendHelpCenter:tSchemaComplianceCheck which is used to  check types, nullability, length of rows against reference values.
Best regards
Sabrina
Anonymous
Not applicable
Author

thanks Sabrina ,

But requirement is I need to reject it from the source input itself  ..my input is tinputfileExcel from there only I have to pass two links one is target orther one is reject .
reject link is not giving all the records ( meaning if I have 5 records in my input I need all the 5 records in my rejected file ) but now if have error in first records .. reject file is giving all "null" for those record and along with message "5jee" is integer but it has string in it .
So kindly help ..
Anonymous
Not applicable
Author

Main out put

=====================

| tLogRow_1 |



|=----+--+---=|



|Name |id|sal |



|=----+--+---=|



|meena|2 |6000|



|sona |3 |400 |



'-----+--+----'







.----+--+---+-----Rejected----+----------------------------------.



| tLogRow_2 |



|=---+--+---+---------+---------------------------------=|



|Name|id|sal|errorCode|errorMessage |



|=---+--+---+---------+---------------------------------=|



|mona| null|null|null |For input string: "1SSS" - Line: 0|

I need records instead of null



'----+--+---+---------+----------------------------------'
Anonymous
Not applicable
Author

Hi,
What does your input look like? How did you set tschemacompliancecheck? Screenshots of job setting will be preferred.
Best regards
Sabrina