Forum Discussion

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