implementig job using join

[4friends]

i have two source files


in souce one i have (1,2,3)

in source 2 i have (1,2,4)

i need target like 3 files in first file(1,2)
2nd file (3)
3rd file (4)

how can we implement plz send me a solution to this.

[Maveric]

Do a full outer join with (1,2,3) and (1,2,4) as left and right links respectively. In the output you will have fields left.key and right .key. Use a transformer with three output links. If both left and right key is same i.e. for records (1,2) then file1. If left key in null (4) then file2. If right key is null then file3. These conditions can be checked in the output link constraints.

[Maveric]

And delete the duplicate post before anyone replies to it.