Forum Discussion
Power Query skipping wrapped text from PDF's Column Headers causing Null values in that column
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 fil...
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.