Forum Discussion
Insert Table.ReplaceValue, before files from folder, have been split into columns?
mmace1 Share sample data with the final result
Here's how I'm combining PDF files from a folder
If the source file has "" in it, like below
Then when Power Query pulls in the file, it generates an extra column - Column2 below.
Instead it should....not do that, and just import the file as it does for tables that lack double quotes. e.g - correct:
If I were doing this manually - no problem, remove the extra column. But I'm importing a ton of tables from PDFs via the 'Import from Folder' functionality, and appending them. So, the columns need to line up.
I just need to either:
Get Power Query to replace, or ignore, those "" prior to the step where it decides how many columns there are
Or do some weird logic - like "If you do this operation and end up with 5 columns, delete column2)