Combining 2 unidentical values of a column

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ds_is_fun
Premium Member
Premium Member
Posts: 194
Joined: Fri Jan 07, 2005 12:00 pm

Combining 2 unidentical values of a column

Post by ds_is_fun »

I have 2 columns from 2 separate sources.
1. Row count from aggr stage.
2. Process_id from surrogate key gen stage.
At any given point of time there would be only 1 value coming in from each of these stages.
I need to combine these 2 into one row output.
How could I achieve that? I tried lookup but that needs key columns.
Havoc
Participant
Posts: 110
Joined: Fri Nov 24, 2006 8:26 am

Re: Combining 2 unidentical values of a column

Post by Havoc »

ds_is_fun wrote:I have 2 columns from 2 separate sources.
1. Row count from aggr stage.
2. Process_id from surrogate key gen stage.
At any given point of time there would be only 1 value coming in from each of these stages.
I need to combine these 2 into one row output.
How could I achieve that? I tried lookup but that needs key columns.
Use a column generator stage from both these links, and generate a column with the same column name and value for both these links. Use this generated column in your join or lookup as the key and you will get your desired output.
Post Reply