Hi,
I am getting some data from a lookupstage, Now I need to join this data with data coming from a DB2 table. I am using Join stage.
My problem here is the column on which I need to join is named differently in DB2 table and in the lookupstage. So I was unable to provide the key name.
Can you give me an idea how can I resolve this issue?
Thanks
Kavuri
Join
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
Re: Join
Use a modify stage to change the column name.
Use a copy stage and move it into a column where the name has been changed to match the DB2 column.
Use a copy stage and move it into a column where the name has been changed to match the DB2 column.
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
I should have been more precise. I was just listing out options. Thanks for the clarification. I would hate for him to think he needed to do both.ray.wurlod wrote:Use one (not both) of the approaches suggested. ...
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com