Forum Discussion

Matthias's avatar
Matthias
Frequent Visitor
8 years ago
Solved

Unpivot Repeating Attribute Value Columns

Hi   I am working on a report in an IT context. I have a table 'Projects', the work of each project can be distributed according to several domains. Users enter this information in Domain - Distrib...
Need Help
  • Sean's avatar
    Sean
    8 years ago

    In the Query Editor

    1) Ctrl+Select the 5 Domain Columns

    2) Transform tab - Unpivot Columns - select Unpivot Only Selected Columns

    3) Select the Value column - click the drop-down button in the column’s header - uncheck the Blank value

    4) Ctrl+Select the 3 columns - ID, Domain1 Percentage and Value

    5) Right-click on any one the selected columns’ Headers - select Remove Other Columns

    6) Finally rename the Domain1 Percentage column - Domain and the Value column - Percentage

    There it is! :smileyhappy:

     

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
8 years ago

In the Query Editor

1) Ctrl+Select the 5 Domain Columns

2) Transform tab - Unpivot Columns - select Unpivot Only Selected Columns

3) Select the Value column - click the drop-down button in the column’s header - uncheck the Blank value

4) Ctrl+Select the 3 columns - ID, Domain1 Percentage and Value

5) Right-click on any one the selected columns’ Headers - select Remove Other Columns

6) Finally rename the Domain1 Percentage column - Domain and the Value column - Percentage

There it is! :smileyhappy: