Forum Discussion

hamishpolson's avatar
hamishpolson
Regular Visitor
5 years ago
Solved

Import error - column not found.

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.

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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