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.
Combining 2 unidentical values of a column
Moderators: chulett, rschirm, roy
Re: Combining 2 unidentical values of a column
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.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.