Separate in columns repetitive attribute

[Duinhir]

Good afternoon,

i hope you can help me. To correctly link parameters to equivalent in the model I separated using "split column" the year from the three elements QTY, Av. net sell and Turnover.

Now I would need to separate in three different columns: QTY, Av. net sell. and Turnover, so that for each Part number and each year I have the three values, but in independent columns.

Is there a command to do so?

Thank you very much!!!

Fabio

[Joe_Barry · Accepted solution]

Hi @Duinhir 

Highlight the Attribute.2 column, go to the Tranform tab in the ribbon then choose Pivot column. Use the Value column in the Value field. In Advanced Options, Choose Don't Aggregate

Hope this helps

Joe