Forum Discussion
Error: Column not found
Dear All, I have created a report, in which the first row was promoted as headers. some of the columns had dates like "03-Jan-23", etc as the headers in the top row. It was working well even afte...
Have you checked the editor again? Did you apply changes and update everything properly? It seems that you keep trying to read a column that does not exist
Hi , I have not changed anything, but still issue is coming up.
Below are 2 screenshots for the steps, after which it is showing error:
and when I move to the next step - "Changed Type1" it is giving error
According to your picture, the column name isn't "44564" but "03-Jan-22", even if the number correspond to that date it's a string. I assume you haven't written it.
The only thing that comes to my mind is to postpone data type change. First unpivot, then rename the column and later on, change the type (if it is possible to you)