I have sequence throwing the error message: “ColumnName and while merging two datatables. The thing is, the column where it fails, it was created by me with a concrete DataType (string). Please see the details below:
First I read one Excel sheet:
Then I read the other (which has almost the same columns as the previous one).
Finally I add a new Column to both datatables indicating that the Type must be String
I print the DataTypes of both datatables
And I get the following:
My question is… why the column ‘Plant Name’ from DataTable1 and ‘Plant Name’ from DataTable2 have different DataTypes if I personally added the column in both of them indicating ‘String’ as the DataType?