Importing Multiple Files from Folder

[Darko_Giac]

Hello all,

I'm currently working on linking two forms within a folder (Form A and Form B, both of which have, for the most part, matching IDs and ~50 other demographic variables). I would then create a report based on only IDs that match between the two forms.

I am importing the two forms by pointing power query to the folder within which Form A and B live

The issue I'm running into is, every week, there is an update that will add new IDs to both forms.

So one week would be 01.01.2018 (Form A) and 01.01.2018 (Form B); the next week will be 01.08.2018 (Form A) and 01.08.2018 (Form B)

I'm just running into an issue when move the 01.01.2018 files into an Archive folder and moving the new files into the folder from which power query is pulling. However, when I refresh, the error "The key did not match any rows in the table" will appear. I know this is because the new files now have new names, but I am wondering whether there is a way to have power query pull from that folder with new file names, as I would just like to keep track of the most recent exports I am working with.

Below is a screenshot which will (hopefully) illumniate the process a little more clearly.

Power Query Screenshot

I would just right click within the "Content" column and add each form as a new query. 

Darko

[v-lili6-msft · Accepted solution]

hi, @Darko_Giac

here is the blog for you to refer to:

Getting data from the latest file in a folder using Power Query

https://medium.com/@wkrzywiec/getting-data-from-the-latest-file-in-a-folder-using-power-query-51dfa4...

Best Regards,

Lin

[Darko_Giac]

Thanks @v-lili6-msft! Worked just as I had hoped!