Hi, I am importing from folder that contain invoices stored as PDFs. The format on page 2 of the invoice is a table that contains the line items I need to import. I always chose page 2 from first file and everything comes through except when the column name has text that is wrapped. The issue is that some months the column names have the column header in wrapped text while other months the the text is not wrapped. Here is an example.
It appears that power query is only reading the first line in the wrapped text and identifying it as a different column name and providing null values instead of the dates in that column. Its also happening in other columns.
The PDFs cannot be edited.
Any advice in fixing this would be appreciated.
Also, I want to solve this problem of power query not recognizing wrapped text as the same as unwrapped text when the data source is PDF. I can get the dates from another column but if this happens to any other column, then there would be no solution. Thr real issue is that power query not only doesnt recognize the column header but it makes all values for that column for that invoice null! In this case its the service period for a few invoices being null. The service period is the date of service for the bill.
