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 afte...
Need Help
Show and Tell
Tips and Tricks
mlsx4's avatar
mlsx4
Memorable Member
3 years ago

Is the same column?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

  • mlsx4's avatar
    mlsx4
    Memorable Member
    3 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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

      • mlsx4's avatar
        mlsx4
        Memorable Member
        3 years ago

        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)