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

Tmap how to output rejections

Hello,

 

New to talend and I have three files inputting to my Tmap and I'm getting the expected results. However I am trying to capture rejected rows and output these also. As you can see from my input one has 120 rows the other 335 and I'm getting the 65 rejected outputs I'm expecting however I can't figure out how to catch the rejected rows from the other inputs. As you can see the output row is 0 and despite trying multiple ways I can't figure it out. Is it because my main input file comicfilm is containing the 65 correct output and I can't track the rejects from the other input files? 

 

Any help is much appreciated.

 

Neil.

0683p000009M1iH.jpg0683p000009M1eQ.jpg

Labels (2)
1 Solution

Accepted Solutions
TRF
Champion II
Champion II

Define the join between the main row and the lookup as an inner join. Then, set the "Catch lookup inner join reject" option to True.
The "Catch output reject" option you are using is for filter rejection.

View solution in original post

2 Replies
TRF
Champion II
Champion II

Define the join between the main row and the lookup as an inner join. Then, set the "Catch lookup inner join reject" option to True.
The "Catch output reject" option you are using is for filter rejection.
Anonymous
Not applicable
Author

Thank you very much that did it. Neil.