Forum Discussion
Type mismatch error when appending tables, works with integers, but not with strings
Hi Anonymous
Can you provide some sample picture after appending the tables?
Best Regards!
Yolo Zhu
Hi Anonymous
Based on your description, your column has string and whole number, did it like the following picture?
If it like this, you can keeo the original column, then put the number to a new column, then use the new column to append. you can refer to the following code.
try Number.FromText([Column1]) otherwise nullAnd you can refer to the following similar thread.
Solved: OLE DB or ODBC error: Type mismatch. (Exception fr... - Microsoft Fabric Community
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your reply. It seems to suggest creating a new column that ignores the text rows by nulling out non-numeric values. However, I need to retain the text values during the append process. Hopefully, the following will help clarify the problem:
Table A
Table B
Append result
The problematic column is "VEHICLE." If I eliminate all rows with text in that column, the append operation works as expected. However, we cannot ignore vehicles with text in their identifiers.
Hi Anonymous
Can you provide some sample picture after appending the tables?
Best Regards!
Yolo Zhu