Forum Discussion
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...
Hi Anonymous
In the column, when you convert number to text or text to number, please check if there are any cells having errorPlease 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
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.
Welcome Anonymous