Specified cast is not valid while create a Datatable variable

Hi everyone,

I am getting this error during this activity I use to split a table into multiple tables.

I think i am getting this error because of variable types. Because when i convert this variables string to number on Excel; it solved.

But i don’t know where should i change at my code.

Here is assign code:

Or anyone who know how may i solve this problem? how may i convert its data type to number? Then i think it will be solved.


1 Like

In your group by function did we try mention as
Function(x) x.Field(of String)(“Siparis No”)

(Of Double) can’t be used unless that column is a double or numerical type

Cheers @mazlumkacar