Hi All,
I have a Parallel job where in I need to perform a join using join stage based on the Key values with different Column Names..
Eg: Emp_id with Manager_id
Can I perform the join on these fields in a join stage?
Rgds,
Hitesh
Joining Columns with Different Column Names
Moderators: chulett, rschirm, roy
Re: Joining Columns with Different Column Names
Or lookup stage instead if data volume is not too high....hiteshm wrote:Hi All,
I have a Parallel job where in I need to perform a join using join stage..
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
Re: Joining Columns with Different Column Names
No, because join stage expects all the input links to have the same column name/s to consider for join key/s. Rename to one common name from one of the previous stages or as noted earlier introduce a new stage like copy stage for renaming. If any database stages are involved use alias.
hiteshm wrote: join using join stage based on the Key values with different Column Names..
Eg: Emp_id with Manager_id
Can I perform the join on these fields in a join stage?
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
Re: Joining Columns with Different Column Names
Hi,
For join stage key column name should be same. You can use a modify stage to change the column name input column (Emp_id) to output column (Manager_id) and then you can use the join stage.
Ram
For join stage key column name should be same. You can use a modify stage to change the column name input column (Emp_id) to output column (Manager_id) and then you can use the join stage.
Ram
hiteshm wrote:Hi All,
I have a Parallel job where in I need to perform a join using join stage based on the Key values with different Column Names..
Eg: Emp_id with Manager_id
Can I perform the join on these fields in a join stage?
Rgds,
Hitesh