How to add data to an existing Power Query

[cmstoren]

Hey - this seems like it should be very simple to do but I'm still struggling! Each week I get a report as a csv file with has lots of superfluous information and merged cells. I've used power query to sort it out the way I want, but can't seem to find a way to add the next weeks csv file without going through the whole process again. Any help would be greatly appreciated! (I can use either windows or mac as I know the mac has a few less features). - Chloe

 

[alansidman]

Why not copy your Mcode from the previous week and paste into the current week.

 

[cmstoren]

Thanks for the reply - I can seem to do it when using my pc but I guess it's just operator failure on the mac. I'm happy to just use the pc at the moment

 

[GraH]

Hey - this seems like it should be very simple to do but I'm still struggling! Each week I get a report as a csv file with has lots of superfluous information and merged cells. I've used power query to sort it out the way I want, but can't seem to find a way to add the next weeks csv file without going through the whole process again. Any help would be greatly appreciated! (I can use either windows or mac as I know the mac has a few less features). - Chloe

Turn your query into a function.
Read from folder, and apply the function to each .csv.
But how can a csv, contain "merged cells"? It's a text file format.

You can actually do the basic set-up, starting all over, where you connect to the folder, use the first file as sample and combine the data.
PQ will create a sample query, a parameter and a function based on the sample query.
Update the sample query with the code you have.
Should get the job done.

When you do not want to redo the previous file, the alternative is to apply the same, but use a filter to only load the latest csv. Then save as file a, b, c, ... as days go by. Basically you create file x as your template.