Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
86
Views
Topic starter
I have a large source file that is compiled three times a week. The file goes to a SharePoint folder and is sourced from there. I want to be able to query the file as it updates but keep the old query and merge a few columns to be able to see changes in a few select columns. I can run a query to determine the order the queries are run, but I still get the update on the file I do not want to change.
Any thoughts?
Posted : 16/04/2023 6:15 pm
Hi Jess,
Why not duplicate the query, run the copy to see the changes, and run the main query only if you still want to run it.
Posted : 21/04/2023 12:20 am