Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Expression.Error: Cannot convert a value of type Table to type Table

Hi,   Here's my case. Thanks for any help on this.    I was first combining Excel files in a query. Then, I wanted to merge this query with a query coming from an OData feed. Here I got a Formula...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi,

     

    I found out what was going on. It was simple in fact.

     

    Both column I was trying to merge were not the same data type so I changed both to Text.

     

    Regards,

ImkeF's avatar
ImkeF
Community Champion
6 years ago

My guess is that the error sits somewhere else in the references queries (either in Requête2 or CrossReference).

Some errors in columns just "surface" when being part of merges like here.

The error-message indicates that you tried to reference a column in squared brackets but wrapped that into quotes, so it became a text instead of a column reference.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

hI Anonymous 

Agree with ImkeF , usually if an error relates to the current query you would see a button "Go To Error".

Please check the source tables' (Requête2 or CrossReference) output.

 

Kind regards,

JB

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

     

    I found out what was going on. It was simple in fact.

     

    Both column I was trying to merge were not the same data type so I changed both to Text.

     

    Regards,