"explicit conversion of double to string is not allowed"

Help Studio
,
1

I use the below code for extracting matching rows on the given condition; but getting the error of “converting Double to string not allowed.” Please help.

dtMaster.AsEnumerable().Where(function(row) dtCancelled.AsEnumerable().Select(function(r) r.Field(Of String)(“Column2”.ToString)).Any(function(x) x = row.Field(Of String)(“Column1”.ToString))).ToArray

2

I think is better that you as what you would like to do, because your expression does not look very good :slight_smile:

3

@glory1
IT Looks Like you want to do join between master and cancelled

So yo can do it with the query syntax (within an assign activity)
(From d1 In dtMaster.AsEnumerable()
Join d2 In dtCancelled.AsEnumerable()
On d1(“Column1”).toString Equals d2(“Column2”).toString
Select d2).toArray

In your Statement constructs like r.Field(Of String)(“Column2”.ToString) are better to avoid. Forcing to String maybe cause this issue give try on r(“Column2”).ToString

But if I am right with the assumption of Data Join also have a look on the Join Datatable Activity