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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] How can I get Rejected Data in tMap component

Hi,
How can I redirect reject data in tMap component?
I do know the Catch output reject (catches the records which are filtered in tMap)  and Catch inner join reject (catches the records which are filtered in tMap by applying inner join).
I tried with an example of state id column which has only numbers as valid data but I inserted a row with some alphabets.
I provided integer as datatype for state id column in the output table of tMap component as I need only valid data to the output table.
I loaded data as a string into tFileInputDelimited component and I want to send the row with alphabet data as a rejected row into a file through tMap.
I can provide state id data type as integer @ tFileInputDelimited component and do the reject option over there but I want to do it using tMap.
Please let me know how I can do it.
Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi,
Please take a look at component  TalendHelpCenter:tSchemaComplianceCheck which is used to v alidate all input rows against a reference schema or check types, nullability, length of rows against reference values.  
Best regards
Sabrina

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Anonymous
Not applicable
Author

Hi,
Please take a look at component  TalendHelpCenter:tSchemaComplianceCheck which is used to v alidate all input rows against a reference schema or check types, nullability, length of rows against reference values.  
Best regards
Sabrina