Join

[kavuri]

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

[kwwilliams]

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.

[ray.wurlod]

Use one (not both) of the approaches suggested.

[kwwilliams]

Use one (not both) of the approaches suggested. ...

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.