Join - dealing with different input column names
Moderators: chulett, rschirm, roy
Join - dealing with different input column names
What are the best practices for dealing with joins where the incoming column names don't match? Is there more than one approach? I thought that renaming column(s) under the input tab for a join will work, but it doesn't. If this is the case, which stage(s) are best suited to do this?
Thanks for any input!
Thanks for any input!
It is not stage but in the link that connects Join and the prior stage. If you rename the column in Join input stage, output stage of the previous gets changed, and hence the actual rename is happening in the previous stage.
More the stage, more the resource been consumed. There are few stages with less/No resource consumption like Copy stage etc.,
More the stage, more the resource been consumed. There are few stages with less/No resource consumption like Copy stage etc.,
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Agree. So if a rename was made, and I see it, why wouldn't it be enough to accomplish now a join on columns that have identical names on the input stage of the join? I am just trying to understand. Maybe I am missing something.kumar_s wrote: ... If you rename the column in Join input stage, output stage of the previous gets changed, and hence the actual rename is happening in the previous stage.
I don't get any error during the design stage. When I pull down the menu for keys to join, the list is blank even that I changed the input names to match where required. I don't know whether this a bug, or something that I just need to learn.kumar_s wrote:Are you getting any error or warning? What is the stage prior to the Join stage?
In this case there are three inputs into this join. The sources for these inputs are two joins and one dynamic rdbms source (table).
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Charter Member
- Posts: 193
- Joined: Tue Sep 05, 2006 8:01 pm
- Location: Australia
Yes but are those columns defined as Keys ?juliank wrote:Agree. So if a rename was made, and I see it, why wouldn't it be enough to accomplish now a join on columns that have identical names on the input stage of the join? I am just trying to understand. Maybe I am missing something.kumar_s wrote: ... If you rename the column in Join input stage, output stage of the previous gets changed, and hence the actual rename is happening in the previous stage.