row merger function in parallel edition?

iq_etl · Post by **iq_etl** » Fri May 30, 2014 5:56 pm

Hi all,

I'm wanting to combine rows like this:

row1 key1 keyword1
row2 key1 keyword2
row3 key1 keyword3
row4 key2 keyword1
row5 key2 keyword2

into

row1 key1 keywords (contains keyword1 + keyword2 + keyword3)
row2 key2 keywords (contains keyword1 + keyword2)

It seems that there was a stage for this in the server edition, but I'm not sure what the parallel equivalent is. I've tried searching, but maybe I'm not phrasing the question correctly. Help?

Thanks.

chulett · Post by **chulett** » Fri May 30, 2014 10:12 pm

There is a Server Row Merger stage and complimentary Row Splitter as well but it doesn't do... this.

ray.wurlod · Post by **ray.wurlod** » Sun Jun 01, 2014 12:31 am

PXPivot stage.

chulett · Post by **chulett** » Sun Jun 01, 2014 8:38 am

With some extra pixie dust thrown in.

verify · Post by **verify** » Mon Jun 02, 2014 6:04 am

Use Pivot Stage and select vertical option in it and you can get your required output.

Regards

chulett · Post by **chulett** » Mon Jun 02, 2014 9:28 am

As noted, it will get you close. Afterwards you'd need to handle the "keywords" (plural) field.

iq_etl · Post by **iq_etl** » Mon Jun 02, 2014 9:56 am

Thanks! I will give it a try.

iq_etl · Post by **iq_etl** » Mon Jun 02, 2014 3:44 pm

Pivot Enterprise + Transformer worked. Thanks again!

DSXchange

row merger function in parallel edition?

row merger function in parallel edition?

Re: row merger function in parallel edition?