Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

  • Anonymous's avatar
    Anonymous
    Not 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.

  • mlsx4's avatar
    mlsx4
    Memorable 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.

  • Anonymous's avatar
    Anonymous
    Not 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!

      • Anonymous's avatar
        Anonymous
        Not applicable

        yup, it is the same column.
        same as the screenshot I had shared initially.