Forum Discussion

anantv's avatar
anantv
New Member
3 years ago
Solved

Copy header column only

Hello, My data table has more than 100 columns. I would like to just copy column headers and paste into excel and verify column names with another table.  How do I just copy column headers only? I ...
Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    Hi anantv ,

     

    In Power Query, just create a new blank query and paste this over the default code in Advanced Editor:

    let
    Source = Table.ColumnNames(queryName)
in
    Source

     

    ...where 'queryName' is the name of the query that you want the list of column names for.

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
3 years ago

Hi anantv ,

 

In Power Query, just create a new blank query and paste this over the default code in Advanced Editor:

let
    Source = Table.ColumnNames(queryName)
in
    Source

 

...where 'queryName' is the name of the query that you want the list of column names for.

 

Pete

anantv's avatar
anantv
New Member
3 years ago

Pete,

Thank you very much. This is exactly the solution, that I needed.

 

Thanks