Forum Discussion

Duinhir's avatar
Duinhir
New Member
1 year ago
Solved

Separate in columns repetitive attribute

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

 

 

  • 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

1 Reply

  • Joe_Barry's avatar
    Joe_Barry
    Icon for Solution Sage rankSolution Sage

    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