Forum Discussion

Sahir_Maharaj's avatar
Sahir_Maharaj
Super User
3 years ago

Here are the general steps:

Sahir_Maharaj's avatar
Sahir_Maharaj
Super User
3 years ago

Here is an example M code to get you started:

 

  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    Super User
    3 years ago
    let
    // Step 1: Get list of PDF files
    Source = Folder.Files("C:\Path\To\PDF\Folder"),
    PDFFiles = Table.SelectRows(Source, each [Extension] = ".pdf"),

    // Step 2: Combine PDF files into single binary column
    CombinePDFs = Table.AddColumn(PDFFiles, "Contents", each Binary.Combine({[Content]})),

    // Step 3: Extract tables from PDF files
    ExtractTables = Table.AddColumn(CombinePDFs, "Tables", each Pdf.Tables([Contents], [Name])),
    ExpandedTables = Table.ExpandTableColumn(ExtractTables, "Tables", {"Data", "Columns"}, {"Data", "Columns"}),

    // Step 4: Clean and reshape data as needed
    // ...

    // Combine all tables into a single table
    CombinedTables = Table.Combine(ExpandedTables[Data])
in
    CombinedTables
    • Sahir_Maharaj's avatar
      Sahir_Maharaj
      Super User
      3 years ago

      This code assumes that all of the PDF files in the folder have tables on their pages.

       

      If some of the files do not have tables or have different structures, you may need to add additional logic to handle those cases.

    • NJamigos's avatar
      NJamigos
      Frequent Visitor
      3 years ago

      Data is not structured as tables in pdf. In my case first page structure is little different from other pages. I did transformation to make both same but when appending to 'transform sample '.. Other pages is repeating first pdf data.

       

      What might I have done wrong?