Moving columns from input tab to output tab
Moderators: chulett, rschirm, roy
Moving columns from input tab to output tab
I have a modify stage in my job. All input column are populated. However, the output columns are empty. I want to move all input columns automatically to output columns without having to import it from somewhere. How do I do it?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You set up Specifications.
Each output column must have a specification.
You can have a KEEP specification to pass through column(s) that do not need to be modified, or a DROP specification to manage column(s) that do not need to be passed through, but not both.
Every other output column needs a Specification. You will note, from its icon, that Specification is a multiple property.
You might also read vmcburney's blog on Learning the Modify Stage
Each output column must have a specification.
You can have a KEEP specification to pass through column(s) that do not need to be modified, or a DROP specification to manage column(s) that do not need to be passed through, but not both.
Every other output column needs a Specification. You will note, from its icon, that Specification is a multiple property.
You might also read vmcburney's blog on Learning the Modify Stage
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 70
- Joined: Thu Aug 14, 2003 6:24 am
- Contact:
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
Of course it stays empty - that's why it's called Runtime Column Propagation. It happens automatically at runtime.abc123 wrote:No, it doesn't work. I enabled RCP across the project, job and stage. I still see the Output tab as empty.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Seems obvious which leads me to believe I am missing the point. Can you do a save of the input tab of the modify stage into a table definition and then do a load into the output tab of the same table definition? It appears your problem is that there is no easy way to drag and drop the link columns from the input to the output column of the modify stage. Doing it via RCP is an option but unless you specifcally want RCP functionality, I would avoid it since as you see it hides important Metadata details like the actual columns.