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 ho...
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

PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity 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