error when merging tables

[paulw]

i am trying to merge 2 tables using fields that are both type whole numbers.

i am getting the follwoing:

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

[v-ljerr-msft]

Hi @paulw,

---

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

---

The error message shows that there is a value "11169A" which is not a number in one of your fields used for merging tables. So please go to remove the value, then the merge table function should work.

Regards