Pivot Table Change Data Source via Power Query Error

[HC1994]

Hi all,

The purpose is to pull through large .csv into Pivot Table for manipulation and aggregation, and be able to change the sources of data fairly intuitively. the .csv is saved in separate location. However, when I try to change the sources of the .csv that the Pivot Table is linking to, if the columns do not match exactly as before, it will error out and tell me that
[Expression.Error] The column 'groupID' of the table wasn't found.
This happens when I click on the "Save&Load" in the Power Query Editor.

Please let me know what's the best the way of go about doing this. It also doesn't have to be Power Query, I just found it to be most intuitive(this will be used by many people).

 

[Rijnsent]

Hi HC,
a couple of options come to mind:
a) make sure that the CSV always has the same columns, also when they are empty/not used (in the program that creates this csvs)
b) make a different pivot for every CSV structure
c) "solve" the different structure in PowerQuery, maybe with some VBA, where you e.g. add a custom column when that column is not in your data: https://support.office.com/en-us/ar...er-query-2dbb579a-915b-4ebd-b622-8e7f3d1d61a6

Hope that gets you started,
Koen