Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
125
Views
Topic starter
Hello!
I'm running PQ to fetch data from a folder (which has roughly 50 workbooks). When PQ refreshes the data, it appends all the new values after each workbook. Something like this
Workbook 1
Workbook 1(new Values)
Workbook 2
Workbook 2(New Values)
and so on!
Can I have it otherwise, instead of appending data it should add new rows for all the new data that is entered in each workbook. Like this
Workbook 1
Workbook 2
Workbook 3
Workbook 1(New Values)
Workbook 2 (New Values)
Posted : 06/12/2021 8:24 pm
Hi Sunny,
You can only specify sort order using one of the columns present in the data, e.g. a date column. You can't simply tell Power Query to append the latest data last based on when it refreshed the data and it appeared in the folder.
Mynda
Posted : 07/12/2021 2:21 am
