Forum Discussion

JoaoMachado's avatar
JoaoMachado
Advocate I
9 years ago
Solved

Automatically Unpivoted Columns

Hi,   I've unpivoted some columns that I need to use in such a way. When I add new columns to the original datasource (Excel file) those will automatically get unpivoted as well, resulting in an er...
Data Modeling
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    JoaoMachado

     

    This should be as expected. You can go to Query Editor - Advanced Editor to see the detailed power query. By default, if you click 'Unpivot Columns', it will use 'Table.UnpivotOtherColumns'. When new columns are added to the original datasource, this new column will also be unpivoted.

     

     

    To get around it, you can select the column and click 'Unpivot Only Selected Columns'. The generated power query will be Table.Unpivot.

     

     

    Best Regards,
    Herbert

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

JoaoMachado

 

This should be as expected. You can go to Query Editor - Advanced Editor to see the detailed power query. By default, if you click 'Unpivot Columns', it will use 'Table.UnpivotOtherColumns'. When new columns are added to the original datasource, this new column will also be unpivoted.

 

 

To get around it, you can select the column and click 'Unpivot Only Selected Columns'. The generated power query will be Table.Unpivot.

 

 

Best Regards,
Herbert

  • JoaoMachado's avatar
    JoaoMachado
    Advocate I
    9 years ago

    Hello, Herbert,

     

    Thank you so very much for your help. It worked wonders!

     

    Sincerely,

    João Machado