Folder of PDFS - importing and appending tables, but sometimes double quotes create extra column

[mmace1]

I have a folder full of PDFs.  I'm importing and appending the tables from those PDFs - but double quote (") are causing additional columns to be generated. 

Background: 

I want to extract from all the files in the folder, [Data Table 1] & [Data Table 2] in the below screenshot. 

When Power Query interprets the file:

• Data Table 1: Comes through fine - with headers
• Junk:  Table I'm ignoring
• Data Table 2: Comes through fine (though as a seperate table from Data Table 1) - without headers

Currently, I'm importing the folder of PDFs 1x, then referencing it 2x using the built-in functionality

1 time to reference [Data Table 1], and 1 time to reference [Data Table 2]

The issue is sometimes the first column of [Data Table 1] or [Data Table 2] has a " in it, which Power Query then interprets as a new column break.  Well, so far it's only occured in [Data Table 2], but I'm sure " will pop up in [Data Table 1] eventually. 

e.g. - Power Query when no " are present

And one with ", - an additional column is generated

Due to the additional column, it naturally messes up the Append function.  

How can I work around this?  I was thinking: 

• Telling Power Query to ignore the " character, prior to the table interpretation
• Telling  Power Query to swap out the " character for something else, prior to table interpretation
• Telling Power Query "If you detect 5 columns, drop the 2nd column"
• Instead of using the built in [Content] expansion (image below), somehow doing this manually with pdf.Tables in a way that achieves the above

Not sure what the best course is though to avoid that extra column messing up the Append function (nor how to do any of the above!)

[Arash_Bhz]

Hi, 
In PowerQuery, use one of the correct PDFs without quotation marks, Ctrl+Click on all field names that you want to keep. Then right-click and select Remove Other Columns. This will remove any extra columns that are added in the future that is not in your selected set of columns. I hope this helps.