Forum Discussion
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 or...
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
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