Input tables in Join Stage

deepa_shenoy · Post by **deepa_shenoy** » Mon Oct 26, 2009 11:44 pm

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

deepak.hsbc · Post by **deepak.hsbc** » Tue Oct 27, 2009 12:03 am

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...

tehavele · Post by **tehavele** » Tue Oct 27, 2009 12:32 am

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.

Kryt0n · Post by **Kryt0n** » Tue Oct 27, 2009 2:35 pm

Or make it a full outer join