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

1 Reply

  • 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