Forum Discussion
se2
2 years agoHelper II
Extract data from PDFS where data not uniform
Hi, I need to loop through some PDFs. While much of the data is uniform, some lines are not. I have figured out how to use power query to extract data from individuals PDFs, therefore accouting dif...
se2
2 years agoHelper II
OK. I think I will create a custom query and use parameters if needed. Will add conditional columns to bring in irregular data. Still not sure how to loop through the files in a folder and apply the custom query to each file.
se2
2 years agoHelper II
looks like loops are in m-code but not in the power question menu.