Error casting type for removing redundant data from datatable

[aqiffm]

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’.”

[B_H_Akshatha_Pai]

change the data type of dtTempFiltered to double

Regards,

[mkankatala (Mahesh Kankatala)]

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!!

[ppr (Peter)]

Field method is stating that this is a double column

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