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 compare the headers in each file

- automate the process

 

Thanks

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!

5 Replies

  • slorin's avatar
    slorin
    Super User
    2 years ago

    Hi,

    with csv files 

    let
    Source = Folder.Files("C:\Temp"),
    csv_files = Table.SelectRows(Source, each [Extension] = ".csv"),
    Headers = Table.Combine(
        Table.AddColumn(
          csv_files,
          "Header",
          each Table.FromRecords({[Name = [Name]] & Csv.Document([Content],null,";"){0}})
        )[Header])
    in
    Headers

    Stéphane 

    • harry1605's avatar
      harry1605
      Regular Visitor
      2 years ago

      Hi Stephane,

       

      Thank you for your response.  I am new to power query so can I confirm the following is correct or if you can correct for me:

       

      1. I have opened a new excel workbook and selected get data from folder and have chosen the combine and transform option

      2. When in the power query editor I go to the transform file step (or is it another step or way) I replace from the let statement with your code - my files are xlsx so replace csv

       

      Thanks

      • 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!

  • dufoq3's avatar
    dufoq3
    Community Champion
    2 years ago

    Hi harry1605, if you upload 2 or 3 files (you can delete all the data just keep header rows and at least one data row) i.e. to google drive and provide here a link with public permissions, we can create a query for you.