Error casting type for removing redundant data from datatable

I have table A and I have table B, I am removing data from table A which exists in table B. So, I am using Linq to remove the data. However I have problem with casting type. screenshot as follows:

Error message: “Assign: Unable to cast object of type ‘System.Double’ to type ‘System.String’.”

change the data type of dtTempFiltered to double


Hi @aqiffm

You have created a dtTempFileterd variable in the assign activity, the variable datatype is in String change the datatype to System.Double.

Hope it helps!!

Field method is stating that this is a double column

change LINQ parts from
d.Field(Of String)(“ColName”) → d(“ColName”).ToString()

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.