Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
96
Views
Topic starter
Each week i receive a new data file, which i save over the existing excel file, but the headers change, this breaks my pivot table - how can i resolve this?
Posted : 11/02/2021 2:37 am
Hi Alan,
It's possible to deal with changing column names - but really the best solution is to fix the problem at source. Can you get the new files created such that the headers are consistent? If not, then I'll see what I can do to fix the issue.
Please attach some sample data so I can see what columns are changing and also provide your query.
Regards
Phil
Posted : 11/02/2021 7:27 am
