Forum Discussion

ctedesco3307's avatar
ctedesco3307
Icon for Resolver II rankResolver II
4 years ago
Solved

Merge Query error columns of same type when they are

Hello  - I'm trying to merge 2 tables into one query but I keep getting Select Colunf of the same type error message - however my columns are of the same type.  Any ideas? thank you 

 

 

 

 

 

Need Help
  • SergioSilvaPT's avatar
    SergioSilvaPT
    4 years ago

    Hi ctedesco3307 

     

    You have to check the data type in Power Query like in the image bellow:

     

     

    Both most be like number "123".

     

    Regards,

    Sérgio Silva 

     
    If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

3 Replies

  • SergioSilvaPT's avatar
    SergioSilvaPT
    Icon for Resolver V rankResolver V
    4 years ago

    Hi ctedesco3307 

     

    You have to check the data type in Power Query like in the image bellow:

     

     

    Both most be like number "123".

     

    Regards,

    Sérgio Silva 

     
    If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
  • ctedesco3307's avatar
    ctedesco3307
    Icon for Resolver II rankResolver II
    4 years ago

    Thanks - but I can't even get that far. When I select the tables I get the error before the query is made. Both columns are of the same type in the tables.