DSXchange

Hi,

I have two input tables Old and New. In the join stage, I am performing a Left Outer Join based on the common ID key.

In the Output tab, under Mapping only one table appears i.e the Old table. I want the New Table columns also to appear.

How do I do this?

Both the tables have the exact same column names and datatypes.

Thanks in advance.

Deepa

Make it right outer or change the link ordering...since your Old table is on left link and you are choosing left outer,Old table is coming in output.

Oh,I misunderstood the fact that you need all the columns from new and old table...

You will have to change the names of all non key columns on the either of the links.Only Key column names should be same.

Or make it a full outer join