Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Pivot table result without aggregate function (string data type)

User_SAPZLSep 8 2022

Hi all,
We'd like to convert table format on the left to table format on the right;
image.pngI have used power query but able to arrange by APPNAME, by USERROLE in 1 file and by APPNAME, by USERGROUP in separate file only as per below.
image.pngHow do i combine both in the format on the top right as mentioned above? Appreciate your help. Thx.
This post has been answered by Stax on Sep 9 2022
Jump to Answer
Comments
Post Details
Added on Sep 8 2022
#oracle, #pivot
12 comments
3,982 views
3 mentions