Forum Discussion

Zaibass81's avatar
Zaibass81
Helper I
3 years ago
Solved

Transform one table column into two columns

Hello,  Looking for some help: The goal is re-shape data based on the ranking. All parts has rank 1 & 2 Only. The desired outcome to transform the data into vertical table where rank2 items appear...
Need Help
  • serpiva64's avatar
    serpiva64
    3 years ago

    Hi,

    you can try the transformation listed in the attached file

    and you obtain this

    If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !

     

serpiva64's avatar
serpiva64
Solution Sage
3 years ago

Hi,

you can try the transformation listed in the attached file

and you obtain this

If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !

 

  • Zaibass81's avatar
    Zaibass81
    Helper I
    3 years ago

    Thank you very much! Excellent solution. As I had to create two different tables, one with filter rank 1 and the other with filter rank 2, I created a unique attribute and joined the two tables. Your solution, however, is more effective.