Page 1 of 1
Joining Columns with Different Column Names
Posted: Mon Sep 10, 2007 5:02 am
by hiteshm
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
Posted: Mon Sep 10, 2007 5:10 am
by Maveric
Use a copy stage in one of the input links and rename the join field Emp_id to Manager_id .
Re: Joining Columns with Different Column Names
Posted: Mon Sep 10, 2007 5:16 am
by iDomz
hiteshm wrote:Hi All,
I have a Parallel job where in I need to perform a join using join stage..
Or lookup stage instead if data volume is not too high....
Re: Joining Columns with Different Column Names
Posted: Mon Sep 10, 2007 5:47 am
by JoshGeorge
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?
Re: Joining Columns with Different Column Names
Posted: Mon Sep 10, 2007 5:53 am
by SURA
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
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