Forum Discussion

paulw's avatar
paulw
Regular Visitor
9 years ago

error when merging tables

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
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

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.:smileyhappy:

 

Regards