Hi All,
I wanted to catch all rows rejected/filtered out of Tmap. I think I configured it correctly but I still can't see any data on the rejected table. Please see my screenshot and please let me know if there's anything wrong with it.
Thanks!
Jo
in fact when you put filter as in your example, data are filtering before mapping. so only data passing the filter go further. put the filter on right side & then data rejected will go in the second output flow as expected. hope it help
hi, Output reject is for reject about filter. Seems that you have no filter in your tMap. Are talking about reject for join ? if so, use inner join reject. regards laurent
Hi Laurent, I have no inner join. I was just filtering the source data (row1) using the condition row1.UWI.substring(0,5).equals("XI977"). As you can see from the screenshot, my source file has 252 rows but only 7 rows satisfied the condition in tmap. What I wanted to do is to catch the other 245 records that did not satisfy the filter.. Is there another way of doing this? Thanks!
in fact when you put filter as in your example, data are filtering before mapping. so only data passing the filter go further. put the filter on right side & then data rejected will go in the second output flow as expected. hope it help