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 have been using 'copy table' and just keeping column headers only for verification.

Thanks

 

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

4 Replies

  • 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

  • rubayatyasmin's avatar
    rubayatyasmin
    Community 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.