DSXchange

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.

Rerun as 'Right and Left Only'.

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.