Forum Discussion

harry1605's avatar
harry1605
Regular Visitor
2 years ago
Solved

Just taking first row

Hello   I have a number of files in a folder and wanted to know how I could in power query   - only take the first (header row) from each file into a single file.  I want to do this so that I can...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi harry1605 

     

    As you are using Folder connector, it would be simple. In "Transform Sample File" query, Use Headers as First Row. 

    Then Keep Top 1 Row. 

    Then go to the combined query, if there is a step called "Changed Type", remove this step. You will have all column headers in the combined query. 

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi harry1605 

 

As you are using Folder connector, it would be simple. In "Transform Sample File" query, Use Headers as First Row. 

Then Keep Top 1 Row. 

Then go to the combined query, if there is a step called "Changed Type", remove this step. You will have all column headers in the combined query. 

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

harry1605's avatar
harry1605
Regular Visitor
2 years ago

Hi Jing,

so sleek and so cool thank you.

 

Followed your instructions I had to de promote the header and take the top row and bingo got what I wanted!

 

Stephane thanks also for taking the time to support.