Row merger

[amal]

Hi,

I would like to merge rows in PX Job. I must use datasets as input.

Any help ?

eg:

dataset in :
abcde df
abcde rg
abcde ip

dataset out :
abcde dfrgip

thx

[sanjay]

U can use Funnel Stage to merge rows if metadata is same for all 3 datasets it will work like a union operator in oracle

Hi,

I would like to merge rows in PX Job. I must use datasets as input.

Any help ?

eg:

dataset in :
abcde df
abcde rg
abcde ip

dataset out :
abcde dfrgip

thx