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! 

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

Telcontar120

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