Power Query - Extract PDF Tables by the Table's Content

Learn how to extract tables from PDF files based on the content of the tables. This technique is NOT reliant on table names or page locations. PLUS, many cool tricks for dealing with data discovery and manipulation exist.

File Download Link:
https://www.bcti.com//wp-content/YT_D...

00:03 Overview of Problem
01:10 File Download Instructions
01:20 Main Issues (Project Overview)
02:08 Connecting to a Folder (Controlling Scop
03:13 Filter for PDF Files
03:43 Remembering Where Records Came From
04:54 Extracting PDF Metadata
05:38 Extracting Tables from PDF Files
06:11 Discovering Needed Tables
06:50 Converting Tables to Rows
07:12 Combining Nested Lists into a Single List
07:31 Searching for the Keyword that Identifies Needed Tables
08:30 Expanding Table Contents
08:43 Promoting the Header Row
08:49 Removing Unwanted Columns
08:59 Unpivoting the Stacked Tables
09:13 Creating Proper Dates
09:36 Removing Unwanted Rows (Errors)
09:59 Loading the Results to Excel
10:07 Building a Report
10:44 Testing for New Data
11:15 Issues with Hardcoded Titles
12:55 Renaming Columns by Position
14:02 Updating the Remaining Code
14:34 Testing the Dynamic Column Name Feature
14:54 Project Conclusion