Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

DataFormat.Error

Hi,

 

I want to merge 2 tables based on 2 columns that are marked as text type. However, when merging I receive below error. It however does not say to which column the error refers. Any idea on how to solve this?

 

DataFormat.Error: We couldn't convert to Number.
Details:
#

Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Hi Anonymous 

    In the column, when you convert number to text or text to number, please check if there are any cells having error

    Please rectify the error or replace error or remove error rows then try to merge


    Let me know if that works for you


    If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

3 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi Anonymous 

    In the column, when you convert number to text or text to number, please check if there are any cells having error

    Please rectify the error or replace error or remove error rows then try to merge


    Let me know if that works for you


    If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    thanks - I removed the automatic step in the query editor that identifies the type. Afterwards it merged and I could see the column with errors.