DataFormat.Error

[Anonymous]

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:
#

[Anonymous]

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.

[PijushRoy]

Welcome @Anonymous 

[PijushRoy · Accepted solution]

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