Import error - column not found.

[hamishpolson]

Hi there,

I have imported an excel file that I have had to manipulate as it has double headers. To achieve this I had to pivot the rows into columns temporarily and then unpivot it back to its original format. This source file is to be updated weekly with a new data file in the same format. One of the columns is 'product' and this can have different values that appear and drop off as relevent in the period that data is pulled for.

The problem I have is that when I update the source file and attempt to refresh, I get an error that a column is not available. The column it highlights is not a column from the original source file but a column from when the data has ben pivoted that includes a now removed product from the source file.

Can anyone please suggest how I can address this so the dashoard can be refreshable?

Thank you in advance.

[watkinnc · Accepted solution]

Before pivoting the data, use the demote headers function from the GUI.  Now when you pivot, your first column becomes Column1, Column2, etc. Now, when you unpivot again, the original tabke

column names won't matter; they'll all be "Column1", "Column2", etc. 

--Nate