DSXchange

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

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

amal wrote: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