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

rubayatyasmin's avatar
rubayatyasmin
Icon for Community Champion rankCommunity Champion
3 years ago

Hi, anantv 

 

Assuming you are using Power BI.

 

1. Just export the table to csv. open the file, the first row should contain column names, just select the first row or the row that contains column names then copy paste it. 

 

or 

  1. Go to Edit Queries > Transform > Structured Column > Expand to New Rows.
  2. Then, go to Home > Keep Rows > Keep Top Rows > 1.
  3. Apply & Close

this will only have column names. 

 

 

  • anantv's avatar
    anantv
    New Member
    3 years ago

    Hi Rubayatyasmin,

    Thank you for the response. 

    I had been extracting column names as option 1.

    I was not able to use the second option (seems very interesting) as Structured column menu grouping is not available in my organization's O365 Power BI.

    I appreciate your help. Thanks.