Altair RISE

A program to recognize and reward our most engaged community members

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

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!

AI Studio

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

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

Scott

Here it is!

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

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