Multiple PDF with different number of pages.

[itsgrady]

I’m trying to combine PDFs through Power Query. The different PDFs have the some columns of information.

Some of the PDFs have two pages. I am able to combine the multiple PDFs but the PDFs with 2 pages, page one is combine but not page 2 is not combine.

The 2nd page of the pdf is continuation of page 1 table but the table on page 2 does not have the a headers.

How can I combine multiple PDFs that have one or more pages?

I did it through Get Data From Folder. I need to drop a new PDF in the folder each day. Some of the PDFs will have two pages.

 

[AlienSx]

hello, @itsgrady would be nice to see one of those files. Let's suppose that first page of each pdf doc contains table headers in the very first row. Then you could combine tables of all pages of the file, promote headers , do the same with each file and then combine tables in the end. You'd need to use some custom function to modify single file. This would look smh like this:

let
    Source = Folder.Files("full_path_to_your_folder"),
    // this is list of binary contents of our files
    pdf_files = Table.SelectRows(Source, each ([Extension] = ".pdf"))[Content],
    // custom function to get pages of each pdf doc, combine tables and promote headers
    get_pages = (bin as binary) => 
        [filter_pages = Table.SelectRows(Pdf.Tables(bin), each [Kind] = "Page")[Data],
        combine_tables = Table.Combine(filter_pages),
        promote = Table.PromoteHeaders(combine_tables)][promote],
    // apply get_pages to the list of file contents and combine tables together
    all_tables = Table.Combine(List.Transform(pdf_files, get_pages))
in
    all_tables