Joining Columns with Different Column Names

[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

[Maveric]

Use a copy stage in one of the input links and rename the join field Emp_id to Manager_id .

[iDomz]

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....

[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.

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?

[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

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