Forum Discussion

waleed111's avatar
waleed111
Helper V
5 years ago
Solved

Refreshing dataset

when i try to refresh my zoho creator dataset it show me this error: There was an error when processing the data in the dataset. so, what is the problem?
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    waleed111 , Check is this column (Added Location) still coming from the source or not. It may have been renamed.

     

    You can create a new connection in a new file and check. If this has been removed or renamed. Then you can right click on the table name in edit query mode and open advance editor. In case it shows a list of the column names, you can rename or remove depending on the need.

    Please keep a backup of file.

amitchandak's avatar
amitchandak
Super User
5 years ago

waleed111 , Please open edit query/Transform data mode, There should be more details on the error. Please check and share the same.

  • waleed111's avatar
    waleed111
    Helper V
    5 years ago

    i find this massage in query editor:

    Expression.Error: The column 'Added Location' of the table wasn't found.

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      waleed111 , Check is this column (Added Location) still coming from the source or not. It may have been renamed.

       

      You can create a new connection in a new file and check. If this has been removed or renamed. Then you can right click on the table name in edit query mode and open advance editor. In case it shows a list of the column names, you can rename or remove depending on the need.

      Please keep a backup of file.