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 after promoting them as headers and "Unpivoting". But now it is showing up error. Below is the screenshot of the same. Tried with some options mentioned in some of the forums, but error still persists. Please advise:
Thanks
8 Replies
- AnonymousNot applicable
mlsx4 , Thanks much for your reply.
There was a step of changing the Type; removed it and created again.
Seems to be working fine. However, in case the issue comes up again, will post it here.
- mlsx4Memorable Member
Hi!
The error indicates that you have no longer a column called in this way. If you have change the name when promoting headers, you should edit it there. If the column has been removed, delete what you have highlighted.
- AnonymousNot applicable
mlsx4 , As mentioned previously, the issue seemed to have resolved after I deleted a step and created again.
However, today when I refreshed the data, the issue has propped again.
Could you please help. Thanks!
- mlsx4Memorable Member
Is the same column?
- AnonymousNot applicable
yup, it is the same column.
same as the screenshot I had shared initially.