Rejected records in merge stage

sourabhverma · Post by **sourabhverma** » Tue Nov 28, 2006 7:22 am

Hi All,

I am joining(Inner Join) two sequential files based on some keys, using merge stage and creating one single file. my requirement is that i want to keep track of all those records which are not matching & keeping in separate file.

Please tell me how to do it.

chulett · Post by **chulett** » Tue Nov 28, 2006 8:32 am

Rerun as 'Right and Left Only'.

Kirtikumar · Post by **Kirtikumar** » Tue Nov 28, 2006 10:24 am

Or else you can have full outer join on the stage. Then after the join using null handling conditions on columns from left data and right data you can filter data.