DSXchange

Posted: **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.

Posted: **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.

Posted: **Sun Jun 01, 2014 12:31 am**

PXPivot stage.

Posted: **Sun Jun 01, 2014 8:38 am**

With some extra pixie dust thrown in.

Posted: **Mon Jun 02, 2014 6:04 am**

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

Regards

Posted: **Mon Jun 02, 2014 9:28 am**

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

Posted: **Mon Jun 02, 2014 9:56 am**

Thanks! I will give it a try.

Posted: **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?