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
Input tables in Join Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 95
- Joined: Thu Sep 24, 2009 12:15 am
- Location: India
-
- Participant
- Posts: 39
- Joined: Sun Apr 15, 2007 11:30 pm
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...
Oh,I misunderstood the fact that you need all the columns from new and old table...
Last edited by deepak.hsbc on Tue Oct 27, 2009 12:47 am, edited 1 time in total.
"Books are as useful to a stupid person as a mirror is useful to a Blind person."