How can i do to merge to examples with the same id?

cdaponte

I have ID´s that can have different types of products. What I want to have the id´s with the different products in the same example.

I leave an image that it will helps you to understand it. Thanks in advanced! 

sgenzer

hmm ok. Have you just tried pivoting using Pivot? Personally I use the GUI in Turbo Prep to do the pivoting as I like it better:



Scott

sgenzer

hi @cdaponte hmm I cannot see an image. Can you please post again?

Scott

cdaponte

Here it is! 

Telcontar120

You can also do this directly either with Pivot or Aggregate operators (depending on exactly what you want your output to look like).