Forum Discussion
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 appearing on the left hand side.
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 !
2 Replies
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 !
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.
